Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Call SQL or LOAD on button click

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,

RC

3 Replies
jason_michaelid
Honored Contributor II

Re: Call SQL or LOAD on button click

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

daveamz01
Contributor III

Re: Call SQL or LOAD on button click

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

Not applicable

Re: Call SQL or LOAD on button click

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;

Community Browser