topic Re: how can i by pass date in listbox . in App Development

how can i by pass date in listbox .

pranali_gawde — Tue, 18 Dec 2018 08:53:40 GMT

Hello,

I have a date as a filter,

However when I select a Date on that Filter, need to show all values before that date.so for that other dimension should show all the values not only possible one.

for eg: if i select 15-dec -2018 it should give data start to till date .

Re: how can i by pass date in listbox .

shiveshsingh — Tue, 18 Dec 2018 09:21:27 GMT

Create a variable which will store your selected date. like Getfieldselections(Date)

Now in document properties, select field event trigger and put a trigger like ='<='&$(vTest)

Hope this helps.

Re: how can i by pass date in listbox .

pranali_gawde — Tue, 18 Dec 2018 09:36:43 GMT

hi thanks for help. Actually i am working on qlik sense.

Re: how can i by pass date in listbox .

pranali_gawde — Tue, 18 Dec 2018 10:35:26 GMT

I used this expression but it is also not working
Kindly suggest.
aggr(only({1<[DOCUMENT DATE]= >}LOCATION_NAME),LOCATION_NAME)

Re: how can i by pass date in listbox .

rangam_s — Tue, 18 Dec 2018 11:42:20 GMT

aggr(only({<[DOCUMENT DATE]= {"<=$(=Max([DOCUMENT DATE]))"}>}LOCATION_NAME),LOCATION_NAME)

Re: how can i by pass date in listbox .

pranali_gawde — Wed, 19 Dec 2018 06:10:34 GMT

I appreciate you .
But it's not working.
i want the document date filter shouldn't apply on location filter.
for eg:I need to show all data from selected date till the first date(as on date) .but when i selected any date on that date the particular location is not available .so it goes into gray but till that date it is there for any of the date. so it should be shows as possible not in gray.