topic Re: Call SQL or LOAD on button click in QlikView

Call SQL or LOAD on button click

Thu, 16 Aug 2012 06:27:27 GMT

Hello,

I have two calendar controls where users can select the date range. I need to create a button which when clicked will trigger a SQL/Load statement in QlikView everytime. Also, I need to pass the dates selected by the user on button click to the sql/load statement. Any help would really be appreciated.

Sample Load:

Load *

from file.qvd

where date >= $(vStartDate) and date <= $(vEndDate)

Cheers,

Re: Call SQL or LOAD on button click

Jason_Michaelides — Thu, 16 Aug 2012 07:02:06 GMT

It is not possible for users to directly trigger a reload. You may be able to achieve it by writing to a file that triggers an EDX-load. Search on this forum for other posts asking the same thing.

Hope this helps,

Jason

Re: Call SQL or LOAD on button click

daveamz — Thu, 16 Aug 2012 07:19:48 GMT

Hello,

See the example attached. You can create a file in the same manner but it will work only locally.

Jason is right, the users won't be able to perform the reload from the server.

Regards,

David

Re: Call SQL or LOAD on button click

Thu, 16 Aug 2012 09:22:49 GMT

While reloading the data if you want users to pass the dates then in that case you can use the following!

Input( str cue [, str caption] )
This function can be used in the script only and opens an input box
that prompts the user for a value during the script execution. The
parameters cue and caption are used as message and caption texts,
respectively. The function returns the entered value.
The input box function returns NULL if the dialog is cancelled,
closed or cannot be shown.
Example:
Load
Input('Enter value', 'Input box') as v,
Recno () as r
autogenerate 3;