Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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 (2)
2 Replies
Contributor III
Contributor III

Bumping the thread. Any pointers would be greatly appreciated!

Contributor III
Contributor III

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