If, Only and Aggr in Filter Pane

[sde821]

Hi all,

I'm new to Qlik and tried some stuff but I couldn't work it out by myself.

I have a filter pane where the user can choose dates:

At the moment my formula is:

(1)      =If(date(Stichtag)>'01.01.2023',date(Stichtag))

Formula (1) shows me all dates bigger then 01.01.2023.

I would also like to combine this with a Aggr-Only formula like this:

(2)      =Aggr(Only({< numdate = {">=$(=vMin)<=$(=vMax)"} >}Stichtag),Stichtag)

Formula (2) gives me the possibility to only choose one date and not more.

I would like to combine (1) + (2). 

I am very grateful for any suggested solution.

Additionaly and if possible I would also like to sort the dates inside the filter pane in descending order. When this would fit into the combined formula above this would be perfekt.

Thank you for all your efforts in advance!

[henrikalmen · Accepted solution]

Try this, it might work:

={<Stichtag={">01.01.2023"}>}Aggr(Only({< numdate = {">=$(=vMin)<=$(=vMax)"} >}Stichtag),Stichtag)

[sde821]

Hi Henrikalmen,

thank you! It works very well!