Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Qlik community,
So I currently have a pivot table which displays historical data for a field, pictured below:
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
Bumping the thread. Any pointers would be greatly appreciated!
Bumping the thread again. Is this at all possible to realise in Qlik Sense?