topic Pivot table expression font color issue in QlikView

Pivot table expression font color issue

Wed, 31 Aug 2011 08:23:00 GMT

Hi,

I have created a Pivot table. There is a requirement to change the font color of an expression using a expression. If the expression has value No then RED other wise BLACK. But this is changing the color of the header (for that dimension) as well . Please find below the screen shot of the issue.

Could you please let me know how to resolve this?

Regards,

Murali

Pivot table expression font color issue

swuehl — Wed, 31 Aug 2011 08:51:49 GMT

Murali,

your problem was discussed several times here in the forum and it seems to be either a bug or a design flaw.

I found this thread a good summary of the discussions:

http://community.qlik.com/thread/8035?start=0&tstart=0

There is also a workaround stated using visual cues, AFAIK this will work only with numericals.

Sorry for no better help,

Stefan

Pivot table expression font color issue

Wed, 31 Aug 2011 08:55:13 GMT

Hi Murali,

does the chart have to be a pivot table? if you use a straight table instead the header will remain the default colouring

thanks

Joe

Pivot table expression font color issue

Wed, 31 Aug 2011 12:12:36 GMT

try this

=if(MinString(C) = 'no', Red(), if(MinString(C) = 'yes', Blue(), Yellow()))

here C is field name but use full expression.

Reg,

Shubhu

Pivot table expression font color issue

Thu, 01 Sep 2011 15:24:52 GMT

Hi Shubhu,

This did not work for me.

I got a confirmation that this is bug. So have to live with it. Lets hope they are going to fix this soon.

Regards,

Murali