topic Re: Date filter pane(single selection and less than) in App Development

Date filter pane(single selection and less than)

Zahmed14 — Mon, 18 Jan 2021 11:56:59 GMT

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 ?

Re: Date filter pane(single selection and less than)

Qlik1_User1 — Mon, 18 Jan 2021 13:41:42 GMT

@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)

Re: Date filter pane(single selection and less than)

Zahmed14 — Mon, 18 Jan 2021 14:11:33 GMT

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 ?

Re: Date filter pane(single selection and less than)

Qlik1_User1 — Mon, 18 Jan 2021 15:09:33 GMT

Try this

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

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

Re: Date filter pane(single selection and less than)

Qlik1_User1 — Mon, 18 Jan 2021 15:10:09 GMT

Try this

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

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