Ignore selections in date dimension to select Max value and last but one

[sgarim41]

Hi All,

I have a peculiar scenario where i have a date as a dimension as follows,

Date_DIM

05-10-2019

07-23-20019

08-19-2019

07-06-2019

I currently use Max(Date_DIM) and Max(Date_DIM,2) to get the top and top-1 values. The trouble now is when i do max  when selected, i get only one value which is fine, but i also need the value before that as well. For example if value 08-19-2019 is selected i need the previous value to be 07-23-2019.

Any help is appreciated.

[jonathandienst]

Try this expression for the date previous to the selected date:

Max({<Date_DIM = {"<$(=Max(Date_DIM))"}>} Date_DIM)

[sgarim41]

This did not work. I also tried converting the max to date format also.

Do you have a sample for this which works?

[Brett_Bleess]

Santosh, have a look at the following Design Blog post, hopefully that may give you some additional ideas to try:

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

There are some other posts in the Design Blog area as well, if you want to search there yourself, use the following link:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett