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:
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.