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

[avinashelite]

hi add a  = before your variable expression this will work

[avinashelite]

Hi,

Gefeildtselection will not work on script, set it as variable in the front and use this in the script this will work.

[#4]

Hi Avinash, can you give me some example please ?

i have add "=" on settings->variable. but in script it return "=GETFIELDSELECTION(DATE)" i need the value of my selected DATE, not the syntax.

Please help me Avinash. Thanks

Regards,

Indra

[avinashelite]

Press CRT+ALT+V you will see your variable,

here use the

=GETFIELDSELECTION(DATE) in the expression without quotes .

can you share that calender qvd , I am not able to reload .

[#6]

Sorry Avinash,

this is my new qvw file, it's not use calendar.qvd but date.xlsx

Thanks

[tresesco]

Use a trigger to set the value of the variable like in attached,

[avinashelite]

Hi Indra,

As @treseco  said you can set trigger , or use this statement in the script which will allow the user to enter the date

• Let vDate = Input('Enter Start Date (MM/DD/YYYY)' , 'Input required');

[#9]

Hi Tres,

i've try your solution and it works. But if i choose more than one date there are no result. It only works for one data.

can you give me the solution please

Thanks

[tresesco · Accepted solution]

Like this?