topic Re: dimension conditional text color in QlikView

dimension conditional text color

Margaret — Thu, 29 Sep 2016 21:22:01 GMT

If a field = 'N' I want the 'N' to be displayed in red, if it is = 'Y', I want 'Y' in Green. I tried this, but it doesn't work:

=if(Conf_Rec_Date='N', Red(Conf_Rec_Date), Green(Conf_Rec_Date))

What am I doing wrong?

Thanks!!

Re: dimension conditional text color

sunny_talwar — Thu, 29 Sep 2016 21:24:23 GMT

You want the color of the text box to be read or green or the text itself?

Re: dimension conditional text color

Margaret — Thu, 29 Sep 2016 21:25:44 GMT

the text itself

Re: dimension conditional text color

sunny_talwar — Thu, 29 Sep 2016 21:30:11 GMT

You can use a calculated if statement to determine the color on the Font tab.

Try this condition:

=if(Conf_Rec_Date='N', Red(), Green())

Re: dimension conditional text color

Margaret — Thu, 29 Sep 2016 21:37:38 GMT

This is in a pivot table, so the font tab doesn't let me specify which column, or if it is supposed to when I click on that "color" box that you circled, it doesn't--its sort of greyed out. As is "font" when I click on the "+" next to the dimension.

and using

=if(Conf_Rec_Date='N', Red(), Green())

in the expression box, puts "RGB(0,128,0)" in my chart field, in black text, when what I want is a green "Y"

Re: dimension conditional text color

sunny_talwar — Thu, 29 Sep 2016 21:41:02 GMT

Oh I see, is this for a dimension or expression?

For dimension:

For expression:

Try using the same expression as above

Re: dimension conditional text color

Margaret — Thu, 29 Sep 2016 21:45:34 GMT

Oh, for goodness' sake...

I always thought since those options are greyed out that means they aren't available but this time I actually tried clicking on it and it worked! Thank you! I hope somebody plans on making that act more intuitively...

Re: dimension conditional text color

sunny_talwar — Thu, 29 Sep 2016 21:47:12 GMT

Hahahahaha