Hi,
I have a Pivot table in Qlik Sense as follows:
Rows: Department No, Department Description ( 1:1 mapping between these two, 1 dept has 1 description)
Column: Location ( since there are multiple locations)
Value: Sum(Profit)
I have added a background color expression for the Value Measure, to highlight negative profit, however if there is an equal amount of positive profit in the row above i.e. for the Department just above the negative profit, I want to highlight the negative value as green, else the negative value should be highlighted yellow.
I have trying to use Above() /Before ()/ Above(Above()) and even Before(Before()) like this:
if(sum(Profit)<0 and <condition on descr>,if(fabs(Sum(Profit))=Above(Sum(Profit), Green(), Yellow()) )
However I am getting it highlighted as Yellow even when the row above has an equal amount of positive profit.
Request your help on this.
Thanks and Regards.
