Date filter pane(single selection and less than)

[Zahmed14]

Hello ,

i have field date that i use in my filter pane , user should select only 1 date and results should be less than or equal the date the user choose

Any Clue ?

[Qlik1_User1]

@Zahmed14 
For user should select only 1 date  -- Use "Always one value selected", So user can only select a single value from a filter. Note by default first value of date field will be auto selected when we use "Always one value selected".

results should be less than or equal the date the user choose --  Use set Analysis 
SUM({<Date={"<=$(=MAX(Date))"}Sales)

[Zahmed14]

Hello Thanks for response  how to get date values which is less than the user choose 
Here as example this ID have several dates  if i select one date the other status does not appear 

If i choose 1/1/2021 no data for this ID although i want to appear all dates execpt 3/1/2021 
if i choose 15/11/2020 i will get only one record as below  although i want to appear the 14/11/2020 and 27/08 and 30/09 and etc ..

how can i write that in terms of date if possible  ?

[Qlik1_User1]

Try this

SUM({<Date={"<=$(vVar)"}Sales)
vVar=Concat(GetFieldSelections(Date),',')

and in all measure use vVar as a part of set analysis.

[Qlik1_User1]

Try this

SUM({<Date={"<=$(vVar)"}Sales)
vVar=Concat(GetFieldSelections(Date),',')

and in all measure use vVar as a part of set analysis.