topic Color Expression Based on Change of Values in QlikView

Color Expression Based on Change of Values

Wed, 19 Aug 2015 19:45:50 GMT

I have a pivot table which shows values (expression) side by side based on a different dimension. Is there a way to write a statement on the font color of the expression to perform the following?

The dimension is numeric, therefore if the expression in the max dimension is different than in any other dimension do X (e.g. bold, black, etc.) or be the default format.

Re: Color Expression Based on Change of Values

varunreddy — Wed, 19 Aug 2015 19:55:09 GMT

Hi,

Try This as background colour for expression,

if(Dimension = max(expression), Blue, RGB(179,179,179))

Hope this works!

Regards,

Varun. K

Re: Color Expression Based on Change of Values

gautik92 — Thu, 20 Aug 2015 06:17:52 GMT

expression->Text Color

if(Dimension=Max(Exprssn),Red(),Yellow())

Re: Color Expression Based on Change of Values

Thu, 20 Aug 2015 13:51:53 GMT

Thanks everyone for your input. I was able to resolve. Here is the syntax I used below in case others have this issue:

IF(ONLY([Expression]) <> AFTER(TOTAL ONLY([Expression])) AND NOT ISNULL(AFTER(TOTAL ONLY([Exoression]))), RGB(3,5,243))