topic Change Color of Data in QlikView

Change Color of Data

tracycrown — Mon, 25 May 2015 15:59:33 GMT

Dear Sir

Please advise how to change the color of data from black into red if Data < Min or Data > Max.

Thanks you so much

Tracy

Re: Change Color of Data

Gysbert_Wassenaar — Mon, 25 May 2015 16:14:29 GMT

Click on the + in front of the expression on the Expressions tab, choose Text color and enter an expression to calculate the color: if(sum(Data)<only(Min) or sum(Data)>only(Max),lightred()).

Re: Change Color of Data

tracycrown — Tue, 26 May 2015 08:51:24 GMT

Dear Gysbert Wassenaar

Very good, thank you very much for your quick response.

Please advise how to make lightred to darkred and how to change the background to yellow color ?. Can you show me how to use colormix2(Data,red(),yellow()).

Thank you

Tracy

Re: Change Color of Data

Gysbert_Wassenaar — Wed, 27 May 2015 08:32:14 GMT

Replace lightred() with red() to get dark red.

See this video for how to use the ColorMix wizard:

Re: Change Color of Data

tracycrown — Wed, 27 May 2015 08:48:09 GMT

Dear Gysbert Wassenaar

Thank you very much for your help.

Tracy