SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


QlikView for Beginners - An Introduction to QlikView


QlikView for Beginners - An Introduction to QlikView

Author
Message
markodonovan
markodonovan
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 658
Comments posted to this topic are about the item QlikView for Beginners - An Introduction to QlikView

http://www.techstuffy.com
twitter: @PracticalQlik
https://twitter.com/PracticalQlik
http://practical-qlikview.tumblr.com
Jerry Hung
Jerry Hung
UDP Broadcaster
UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)UDP Broadcaster (1.5K reputation)

Group: General Forum Members
Points: 1454 Visits: 1208
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/

64-bit is 255MB

SQLServerNewbie

MCITP: Database Administrator SQL Server 2005
YSLGuru
YSLGuru
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1852 Visits: 1665
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
markodonovan
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 658
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

http://www.techstuffy.com
twitter: @PracticalQlik
https://twitter.com/PracticalQlik
http://practical-qlikview.tumblr.com
YSLGuru
YSLGuru
SSCommitted
SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)SSCommitted (1.9K reputation)

Group: General Forum Members
Points: 1852 Visits: 1665
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
markodonovan
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 658
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

http://www.techstuffy.com
twitter: @PracticalQlik
https://twitter.com/PracticalQlik
http://practical-qlikview.tumblr.com
markodonovan
markodonovan
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 658
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

http://www.techstuffy.com
twitter: @PracticalQlik
https://twitter.com/PracticalQlik
http://practical-qlikview.tumblr.com
markodonovan
markodonovan
SSC Rookie
SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)SSC Rookie (46 reputation)

Group: General Forum Members
Points: 46 Visits: 658
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

http://www.techstuffy.com
twitter: @PracticalQlik
https://twitter.com/PracticalQlik
http://practical-qlikview.tumblr.com
rickybranch1321
rickybranch1321
Forum Newbie
Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)Forum Newbie (3 reputation)

Group: General Forum Members
Points: 3 Visits: 1
Thanks for providing an excellent article on QlikView.
For more information on QlikView visit QlikView Training in Hyderabad








Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search