Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Partner
Partner

how can i by pass date in listbox .

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 .

 

 

 

Tags (1)
5 Replies
shiveshsingh
Honored Contributor

Re: how can i by pass date in listbox .

Hi

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.

Partner
Partner

Re: how can i by pass date in listbox .

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

Re: how can i by pass date in listbox .

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

Re: how can i by pass date in listbox .

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

Partner
Partner

Re: how can i by pass date in listbox .

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.