topic Text colour first character in QlikView

Text colour first character

Tue, 27 Mar 2012 08:22:05 GMT

Hi Guys,

I have a straight table that has a field called [Rejection Reasons], in some instances the results in this field are only ',' or a correct reason , but preceeded by a comma.

I dont want to see the first comma in the chart,

In the demension I have gone into [Text colour] and put in the following :

if([Rejection Reasons]=',',RGB(255,255,255))

That works for the ones that are only a comma, I then tried variations of to look for the ones that start with the comma , but they were changing all the text white ,

if ( left ([Rejection Reasons],1)=',',RGB(255,255,255)))

Can anyone help, I am looking to change comma text white when there in ONLY a comma OR when the statemnt starts with a comma

Thanks a mill

Anne

Text colour first character

Anonymous — Tue, 27 Mar 2012 10:17:54 GMT

Hi,

Try:

=if([Rejection Reasons] like ',*' ,RGB(255,255,255))

Kind Regards

Razak

Text colour first character

Tue, 27 Mar 2012 11:47:53 GMT

Hello Anne,

can also be - =If(Mid([Rejection Reasons],1,1)=',',RGB(255,255,255))

Regards

Stive

Brasil

Text colour first character

Tue, 27 Mar 2012 12:27:07 GMT

Thanks Guys

They both work if I wish to change all the text White

I actually am lookting to just change the first character white so --

If ( The first character =',', then make the first character RGB(255,255,255), RGB(0,0,0))

Any ideaas how this could be donw,

I mean I could trim it on Load in the script but I would rather just change it within the chart

Any advice appreciated

Thanks

Text colour first character

swuehl — Tue, 27 Mar 2012 12:41:11 GMT

I believe the format codes are affecting the complete string, you can't format single characters / substrings.

Why not just remove the first character in your expression?

=mid([Rejection Reasons],2)

Text colour first character

Tue, 27 Mar 2012 12:44:07 GMT

Swuehl,

Thanks I sometimes miss the obvious,

So simple and it works perfectly

Thanks