Reload Data Based on Selection

[#1]

Hi,

I have a question, i want to reload qlikview page when click a button i've made. When i select a date from list box (ex: 1/1/2010) and click submit. So the only show data is data on 1/1/2010 only. I have made a variable to get selected date from listbox with GETFIELDSELECTION(DATE). In script page, i put WHERE condition to select transaction based on selected date i've submitted.

but it returns this error :

Error in expression:

GETFIELDSELECTIONS is not a valid function

LOAD NAME,

     QTY,

     TRX_DATE

FROM

[..\transaction.xlsx]

(ooxml, embedded labels, table is Sheet1)

Where TRX_DATE = GetFieldSelections(DATE)

Can you help me to solve this problem

really appreciate your help. Thanks

[timanshu]

Make a trigger that firsts set the value of variable to the expression getfieldselections(Date).

Then add another trigger  to reload script.

in script add where clause  like -  where date > alt( $(var),'1/1/1900') where '1/1/1900'  is default date to load when variable is null.

[#3]

Hi Tres,

Yes, big thanks for your help Tres.

It solved my problem.

Thanks.

Regards,

Indra