QlikView for Beginners - An Introduction to QlikView

  • markodonovan

    SSC Veteran

    Points: 260

    Comments posted to this topic are about the item QlikView for Beginners - An Introduction to QlikView

  • Jerry Hung

    SSChampion

    Points: 12908

    Direct link to download page, without registration (the link in article leads to registration before showing you this link @@)

    http://us.demo.qlikview.com/download/[/url]

    64-bit is 255MB

    SQLServerNewbie MCITP: Database Administrator SQL Server 2005
  • YSLGuru

    SSC-Insane

    Points: 21495

    Mark,

    I have not read thru the entire article yet and so this question may be directly answered in it but a quick skim thru it did not seem to indicate the answer I seek is in the article.

    I have been looking for some time now an application that will enable me to produce what i would think of as a dashboard. A dashboard being a window consisting of 1 or more parts in which each part is displaying the results of some ODBC/ado complaint data source (primarily a query or view from a SQL Server database) in either a grid or a chart/diagram that has some sorting and or filtering capabilities. Currently I often find myself copying the results from the data grid in SSMS to Excel and re-sorting them and even performing calculations and all because there is no way in SSMS to do anything with the results in the grid save for copy and paste to send them somewhere else for filtering and sorting and so on.

    The best way to explain what I am looking for is to give an example.

    Let’s say I have a SQL database hosted on SQL Server 2005. Within my database there are a number of tables that comprise reporting data such as who asked for what report and when as well as what criteria was specified each time. Currently I have a snippet of T-SQL consisting of a temp table and several query’s that pull from that temp table which when run altogether produce a number of results in the grid results area of a SSMS window. While the code snippet has most of the criteria hard coded such as dates (From – To) there is no way aside from manually editing it easily change the criteria or to filter the results (or re-sort them) without req-querying the source or the temp table.

    What I would like if a dashboard that takes each query result in my code snippet and shows it in a separate grid which is sortable and filter-capable without having to re-run the query’s.

    Does that sound like something that QlikView can do?

    Thank you

    Kindest Regards,

    Just say No to Facebook!
  • markodonovan

    SSC Veteran

    Points: 260

    Hi YSLGuru,

    You should be able to do this with QlikView.

    In the past I have created dashboards on the SSRS reportserver database in QlikView to check the performance on the

    reports being run by users and what types of reports were being run.

    Mark

  • YSLGuru

    SSC-Insane

    Points: 21495

    markodonovan (12/17/2012)


    Hi YSLGuru,

    You should be able to do this with QlikView.

    In the past I have created dashboards on the SSRS reportserver database in QlikView to check the performance on the

    reports being run by users and what types of reports were being run.

    Mark

    I've downloaded the PE edition and am trying to do what I would call a simple dashboard (using a SQL Query in my SQL Server database that returns a few fields ) and I can't find any way that you can use this thing without Excel as the source. I get why the Wizard might be hard coded to pull from xls files only but no where in the menu can I find where you create/setup some kind of connection to an ODBC compliant source like SQL Server. is this a limitation of the free pe edition, that you can only use Excel files as the data source? The reference manual mentions using ODBC connections but darned if I can see where within QlikView you do this.

    Is there any kind of demo that deosn't use an Excel file? I can see the appeal of using Excel as the data storage but if I am going to do that then I could use Excel to shuffle and report on the data without QlikView.

    What am I missing?

    Kindest Regards,

    Just say No to Facebook!
  • markodonovan

    SSC Veteran

    Points: 260

    Hi YSLGuru,

    Hopefully the following notes will point you in the right direction for using ODBC connections with QlikView.

    Create an ODBC Connection in QlikView

    1. Open your QlikView application.

    2. Select the File Menu, then select Edit Script.

    3. Select ‘ODBC’ from Database dropdown list and then click the ‘Connect…’ button.

    The ‘Connect to Data Source’ screen will be displayed.

    4. All System DSN’s will be displayed, if you need to see any User DSN’s you need to select the ‘Show User DSN’s checkbox at the bottom of the screen.

    5. Enter the username and password for the DSN you have selected.

    6. Click on the ‘Test Connection…’ button to verify that the ODBC connection is setup correctly and that you are using the correct username and password.

    7. Click OK on both screens then the ‘ODBC CONNECT’ command will be added to your load script.

    You can see from the example below that the username\password have been encrypted.

    ODBC CONNECT TO MyTestDSN (XUserId is fWSDQZFMeD, XPassword is LcTfCRFMLLZEHHC);

    2. Click the SELECT button.

    3. The ‘Create Select Statement’ screen will be displayed.

    4. For each table you want to read data into your QlikView application:

    5. Select the table from the ‘Database Tables’ list.

    6. Select the Fields you wish to add from the Fields list. If you select all fields as ‘*’ then click on the ‘Preceding Load’ option so that all fields are displayed in the script.

    7. Click the Add button.

    8. Once you have finished adding tables click the OK button.

    Finally you need to reload the document by clicking on the reload button or Ctrl+R.

    Mark

  • markodonovan

    SSC Veteran

    Points: 260

    Hi there,

    Just to let you know I will be soon doing a FREE promotion for the Kindle version of Practical QlikVIew.

    If you would like to learn QlikView for FREE or know someone who would please follow me on twitter\tumbler where I will post the dates when the free promotion is on.

    http://practical-qlikview.tumblr.com/post/51094787494/get-a-free-copy-of-practical-qlikview-worth-27

    Thanks

    Mark

  • markodonovan

    SSC Veteran

    Points: 260

    Hi all,

    The Practical QlikView book is free on kindle until 28/5/13 11:59PM PST.

    Remember you don’t actually need a kindle to download and use this free book.

    You download the kindle application from amazon.com.

    Thanks

    Mark

  • rickybranch1321

    Grasshopper

    Points: 13

    Thanks for providing an excellent article on QlikView.
    For more information on QlikView visit QlikView Training in Hyderabad 

Viewing 9 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply