topic Condition in load Script in QlikView

Condition in load Script

Mon, 25 May 2015 09:51:19 GMT

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