If, Only and Aggr in Filter Pane

sde821 — Wed, 21 Feb 2024 09:24:32 GMT

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!

Re: If, Only and Aggr in Filter Pane

henrikalmen — Wed, 21 Feb 2024 10:54:38 GMT

Try this, it might work:

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

Re: If, Only and Aggr in Filter Pane

sde821 — Wed, 21 Feb 2024 11:06:50 GMT

Hi Henrikalmen,

thank you! It works very well!

topic Re: If, Only and Aggr in Filter Pane in App Development

If, Only and Aggr in Filter Pane

Re: If, Only and Aggr in Filter Pane

Re: If, Only and Aggr in Filter Pane