topic Re: Color in QlikView

Color

upaliwije — Sun, 24 Nov 2013 04:45:28 GMT

In my pivot table I have some negative figures which I want to show in red color. Pls someone tell me how to do it

israrkhan — Sun, 24 Nov 2013 05:18:05 GMT

chart properties,on expression tab, click the plus sign to expand the expression, and double click on text color,

put your condition like if(sum(value)<0, Red(), Black())

upaliwije — Sun, 24 Nov 2013 05:35:08 GMT

It is not working

israrkhan — Sun, 24 Nov 2013 05:41:52 GMT

share your expression or screen shot, where are you entering

israrkhan — Sun, 24 Nov 2013 09:28:51 GMT

hi ,

go to pivot table properties>> visual cues >>

left down,put values in, upper >= 0 , lower <=0

done

upaliwije — Sun, 24 Nov 2013 15:40:36 GMT

This is fine and working. How can make the text blink and bold when the certain condition are met

israrkhan — Sun, 24 Nov 2013 17:16:28 GMT

if working then close the thread by marking correct answer..

and there after lower and upper limit, for text color, you can also make italic and bold..