Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
LesJean
Contributor III
Contributor III

Flag changes from day to day inside a pivot

Hello Qlik community,

So I currently have a pivot table which displays historical data for a field, pictured below:

lead.png

I'd like to add a column at the end, which compares the last 2 days available (in this case, it would compare data from the 2019-11-22 to data from the 2019-11-21). The column would then display TRUE if the data was the same or FALSE if the data changed. In an Excel pivot, the formula would look like something like this:

=E1=D1

Obviously, it would be static in this case. I do need the column to be dynamic (using the last 2 days instead of 2 fixed days). I'm having some trouble wrapping my head as to how do to this in Qlik.

Any help would be greatly appreciated,

LesJean

Labels (1)
2 Replies
LesJean
Contributor III
Contributor III
Author

Bumping the thread. Any pointers would be greatly appreciated!

LesJean
Contributor III
Contributor III
Author

Bumping the thread again. Is this at all possible to realise in Qlik Sense?