Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

simotrab
Contributor II

Choose last but one date

Hi community,

short question about dates: how could I choose the last but one date from a group of date?

The formula I need is something like

today()-LastButOneDate()

Thanks in advance!

Tags (2)
1 Solution

Accepted Solutions

Re: Choose last but one date

Perhaps like this: Today() - Max(YourDateFieldHere, 2)


talk is cheap, supply exceeds demand
2 Replies

Re: Choose last but one date

Perhaps like this: Today() - Max(YourDateFieldHere, 2)


talk is cheap, supply exceeds demand
simotrab
Contributor II

Re: Choose last but one date

Thanks a lot!

Community Browser