topic How can we set text color in pivot table when data is null? in QlikView

How can we set text color in pivot table when data is null?

Wed, 23 Jun 2010 17:35:26 GMT

Hi all, I try to set text color.
I want the Node that starts with "TTL___" and "STTL" have blue color. And I set the text color with this code


if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL'),RGB(0,0,204),black())

It's work. But some data still not change the color. I'm not sure, its will concern with the value of another dimension that has value = 0.

So I try to use suppress nulls data. But some rows still have a problem, the text in Catalogue column is not change color. But in the same row, some data already change to blue color.

Now I try to change expression in text color to support my design.
I use this code:


if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL') ,RGB(0,0,204),
if((if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL'),RGB(0,0,204),black()=black()and if((Amt.=0),1,0)=1)) ,RGB(0,0,204),black()))

It's nearly the design what I want. The texts that start with 'TTL___' and 'STTL' changed to blue color. But the others texts that has null value change the color too.

Could someone help me or suggest any better way to handle these issues?

Regards

How can we set text color in pivot table when data is null?

Wed, 23 Jun 2010 18:30:45 GMT

If I understand correctly, you want to change color of data(amt=0) to blue also.

Please attached I applied the same expression for text amt and % you have for catalogue. May be you can refine your expression, not sure about that.

=
if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL') ,RGB(0,0,204),
if((if((mid(FICO_NodeGroup,1,3)='TTL') or (FICO_NodeGroup='STTL'),RGB(0,0,204),black()=black()and if((Amt.=0),1,0)=1)) ,RGB(0,0,204),
black()))

How can we set text color in pivot table when data is null?

Thu, 24 Jun 2010 03:29:01 GMT

Hi,Devang

Thank you for your respond. Actually I want to change text color of field that has word "TTL__" and "STTL". Now it's work but it's also change text color of field that has word "GL" and "CE" too.

How can I ignore FICO_NodeGroup that has word "GL" or "CE" ?

How can we set text color in pivot table when data is null?

Thu, 24 Jun 2010 17:22:32 GMT

Hi, Any one have work around on this ? Pls help me. Regards

How can we set text color in pivot table when data is null?

Thu, 01 Jul 2010 07:33:10 GMT

I still don't know how to fix this problem.

topic How can we set text color in pivot table when data is null? in QlikView

How can we set text color in pivot table when data is null?

Hi all, I try to set text color.I want the Node that starts with "TTL___" and "STTL" have blue color. And I set the text color with this code

So I try to use suppress nulls data. But some rows still have a problem, the text in Catalogue column is not change color. But in the same row, some data already change to blue color.Now I try to change expression in text color to support my design.I use this code:

It's nearly the design what I want. The texts that start with 'TTL___' and 'STTL' changed to blue color. But the others texts that has null value change the color too.

Regards

How can we set text color in pivot table when data is null?

How can we set text color in pivot table when data is null?

How can we set text color in pivot table when data is null?

How can we set text color in pivot table when data is null?

Hi all, I try to set text color.
I want the Node that starts with "TTL___" and "STTL" have blue color. And I set the text color with this code

So I try to use suppress nulls data. But some rows still have a problem, the text in Catalogue column is not change color. But in the same row, some data already change to blue color.

Now I try to change expression in text color to support my design.
I use this code: