Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
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.

Labels (1)
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.