Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Condition in load Script

Hi all,

I have a question, i want to load a script based on selection. When i input a date and click submit, so the page will reload and show data based on selected date. The problem is, i cant load all data again, i want to load all data when user doesn't input date.

If user input date so it will run:

Data:

LOAD NAME,

     QTY,

     TRX_DATE

FROM

[..\transaction.xlsx]

(ooxml, embedded labels, table is Sheet1) Where TRX_DATE = '$(tes)';

----------------------------------------------------------------------------------------------------------

If doesnt input date (left input column blank) so it will run:

Data:

LOAD NAME,

     QTY,

     TRX_DATE

FROM

[..\transaction.xlsx]

(ooxml, embedded labels, table is Sheet1);

Can you give me the solution to solve this problem. I attached my qvw file here.

Thanks

Regards,

Indra

0 Replies