Qlik Community

App Development

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

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
pranali_gawde
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 .

 

 

 

5 Replies
shiveshsingh
Master
Master

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.

pranali_gawde
Partner
Partner
Author

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

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

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

pranali_gawde
Partner
Partner
Author

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.