Dynamic queries and variables

[#1]

Hi there,

I am pretty new to Qlikview and have a few questions - would you be able to help?

1. Is it possible for me to run an SQL query based on user selections? For example, if a user were to select account ID 999, could I then run a query to pull back all data for account 999?
2. Has anyone used QV Source? I am looking to do the same thing for this, using the Google Analytics connector. If someone selects the 'about us' page, then can I automatically fire off a query to Google Analytics to find data about this page?
3. Finally, I have been playing with Variables to create a URL. For example, if the user selects the name John, I want the URL to show as www.domain.com/john. At the minute, I am getting www.domain.com/name:john. Do you know why I have the extra 'name'?

Thanks a lot in advance for the help!!!!

[prabhu0505]

1. This is doable by leveraging Qlikview Management API. - Out of box thing you have to architect this solution.

From QV Publisher task, values can be passed to dashboard variables. So if there are limited account types, multiple tasks can be created. - Directly available solutions with boundaries.

3. ='www.domain.com/'&vTest - this should work.

[petter]

1) Yes you can use the feature called DIRECT DISCOVERY. This will allow you to have a dynamically and automatically generated SQL query to run based on user selections.

2) No - QVSource can not use DIRECT DISCOVERY it is based on being employed as part of a load script. Have a look at QVSource Braindump on Slideshare which verify this.

3) It is probably because you used GetCurrentSelections()-function - but you could get hold of the selected value by using another method or you could simply remove the "name:" part before concatenating it with the URL-path.