If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.
I have set different filters in a table, the data looks like this:
What I want to do: I always want to calculate the difference between the last two purchase dates. I want to display this in the column Difference price.
I have already tried =Date(Max(Date)-1), but unfortunately I can't get any further. Can anyone give me a hint?
FirstSortedValue(Total <Id> [Purchase price], -[Purchase date])
FirstSortedValue(Total <Id> [Purchase price], -[Purchase date], 2)
View solution in original post
Thanks a lot, works perfectly!