Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

Color Expression Based on Change of Values


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.

Tags (1)
1 Solution

Accepted Solutions
Not applicable

Re: Color Expression Based on Change of Values

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))

3 Replies
varunreddy
Contributor III

Re: Color Expression Based on Change of Values

Hi,

Try This as background colour for expression,

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

Hope this works!

Regards,

Varun. K

Highlighted
gautik92
Valued Contributor III

Re: Color Expression Based on Change of Values

expression->Text Color

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

Not applicable

Re: Color Expression Based on Change of Values

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))