topic How to change text color base on data? in QlikView

How to change text color base on data?

Tue, 08 Jun 2010 17:00:20 GMT

Hi all, I try to set text color.

I want the node that start 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())

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

[View:http://community.qlik.com/cfs-file.ashx/__key/CommunityServer.Discussions.Components.Files/11/3010.textcolor.zip:550:0]

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

Thank you.

How to change text color base on data?

Oleg_Troyansky — Wed, 09 Jun 2010 00:52:28 GMT

I'd say - you are doing everything right. From what I can see, the color is not propagated in the "FICO_NODEGROUP" column( because the attribute is not defined there) and in the last set of columns, where your Period is NULL. So, if you copy your Text Color formula into the color attribute of the "FICO_NODEGROUP" dimension, and suppress nulls (which I think you need to do anyway), everything will be fine.

How to change text color base on data?

Wed, 09 Jun 2010 04:58:02 GMT

Hi Oleg, I already try to change my project follow your suggestion. It's suppress null data.

But some row still has a problem. If you can see from my QVW or picture( in row number 50), the text in Catalogue column is not change color. But in the same row, some data already change to blue color.

Furthermore can I shows all data by not suppress null value?

Do we have the way to handle its?

How to change text color base on data?

Thu, 10 Jun 2010 11:03:46 GMT

Hi all, 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 text that start with 'TTL___' and 'STTL' changed to blue color. But the others texts that has null value change the color too.

Can someone suggest me, please?

Thank you.

How to change text color base on data?

Mon, 21 Jun 2010 07:53:06 GMT

I still stuck with this problem, Could anyone tell me the solution to solve this problem?

How to change text color base on data?

Mon, 21 Jun 2010 11:03:44 GMT

Hi,

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

Regards

How to change text color base on data?

Wed, 23 Jun 2010 05:38:24 GMT

Is the problem come from the null value. Can we set text color when data has null value?

I found that the RGB color not work on null value, right???

If the problem from the RGB color, Can I set text color by use anothe function?

topic How to change text color base on data? in QlikView

How to change text color base on data?

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

How to change text color base on data?

How to change text color base on data?

How to change text color base on data?

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 to change text color base on data?

How to change text color base on data?

How to change text color base on data?

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()))