topic Re: Dynamic queries and variables in QlikView

Dynamic queries and variables

Mon, 17 Aug 2015 16:07:58 GMT

Hi there,

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

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?
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?
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!!!!

Re: Dynamic queries and variables

prabhu0505 — Mon, 17 Aug 2015 17:38:56 GMT

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.

Re: Dynamic queries and variables

petter — Mon, 17 Aug 2015 17:49:49 GMT

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.