how can i by pass date in listbox .

[pranali_gawde]

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 .

[shiveshsingh]

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]

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

[pranali_gawde]

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

[rangam_s]

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

[pranali_gawde]

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.