Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Qlik community,
I have 4 fields in a pivot table - Year, sx, sum(A) as A and sum(B) as B.
This is the table:
Is it possible to color the background of A and B when for each year sum(A) > sum(B)?
For example I'd like add color on the following row of the table:
Is it possible? If it is how can I do so?
thanks
Hello,
You should write the "background color expression" part in the measure this:
if(sum(a)>sum(b), RGB(0,0,255))
If you will to implement this solution, you should write this expression to column A and column B "background color expression" part both.
Regards,
Tommy.