Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Refer previous date value using below()

I have to refer to a previous date value. I have an expression which gives me Maxdate value month wise. I need to calculate the previous day value in the next column. That is, I need something like : Below( Previous calculated column). But it is not working. Any help is appreciated. I am using a straright table.

Thanks.

11 Replies
sparur
Specialist II
Specialist II

look at the attachment

Not applicable
Author

Thanks a lot Anatoly. I was struggling with this AGGR, RANK and IF ordering. Now i would look into it carefully and improve my knowledge base for sure.