topic Re: Reload Data Based on Selection in QlikView

Reload Data Based on Selection

Mon, 25 May 2015 07:37:20 GMT

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

Re: Reload Data Based on Selection

avinashelite — Mon, 25 May 2015 07:41:33 GMT

hi add a = before your variable expression this will work

Re: Reload Data Based on Selection

avinashelite — Mon, 25 May 2015 07:43:02 GMT

Hi,

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

Re: Reload Data Based on Selection

Mon, 25 May 2015 07:44:43 GMT

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

Re: Reload Data Based on Selection

avinashelite — Mon, 25 May 2015 07:47:45 GMT

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 .

Re: Reload Data Based on Selection

Mon, 25 May 2015 07:50:59 GMT

Sorry Avinash,

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

Thanks

Re: Reload Data Based on Selection

tresB — Mon, 25 May 2015 08:07:13 GMT

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

Re: Reload Data Based on Selection

avinashelite — Mon, 25 May 2015 08:14:33 GMT

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');

Re: Reload Data Based on Selection

Mon, 25 May 2015 08:25:33 GMT

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

Re: Reload Data Based on Selection

tresB — Mon, 25 May 2015 08:50:37 GMT

Like this?

Re: Reload Data Based on Selection

timanshu — Mon, 25 May 2015 08:56:23 GMT

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.

Re: Reload Data Based on Selection

Mon, 25 May 2015 09:22:20 GMT

Hi Tres,

Yes, big thanks for your help Tres.

It solved my problem.

Thanks.

Regards,

Indra