topic Re: Executing script when clicking a button in QlikView

Executing script when clicking a button

Fri, 20 Nov 2020 18:02:30 GMT

Hi all,

Now, I have made a script in my main "Edit Script" tab. The script asks a parameter to the user and then uses it to query a database and shows the results in a straight table. When I click "Reload" those actions are performed.

I'm adding another table to my qlikview document that will get the information from a different query. This query will take longer to run, so I dont want Qlikview to execute it if it is not necessary. That is why I want to create a button in my document that when clicked will prompt the user for a value, perform a query to a database through ODBC and the n populate a table.

I havent been able to find how to do it in the button properties, does anyone has done this before?

Thak You!

Re: Executing script when clicking a button

sinanozdemir — Tue, 24 Nov 2015 22:00:36 GMT

You can include the below expression in your load script:

Input() will prompt users to enter a value:

Then you can vInput in your load script to reduce the size of your load. You can of course use Reload action for this.

Hope this helps.

Re: Executing script when clicking a button

rwunderlich — Tue, 24 Nov 2015 23:30:59 GMT

What you want to read up on is "Partial Reload". That allows you to retain some tables and replace others in the reload.

-Rob

Re: Executing script when clicking a button

tamilarasu — Wed, 25 Nov 2015 04:43:25 GMT

Hi,

Sample script. Check the attachment

Set vQueryExecute ='';
Let vQueryExecute=Input('Do You Want to Run the Query? Type Yes or No', 'Query Execute Confirmation');

If (Upper(vQueryExecute)='YES') then
    Data:
    LOAD * INLINE [
    ID, Name
    1, A
    2, B
    3, C
    ];
ENDIF

EXIT Script;