Text Color Expression

rtr13 — Sat, 16 Nov 2024 19:27:36 GMT

Hi Everyone, I am currently trying to add color to one of the rows in my pivot table and everything works except when trying to convert some of the values that sit in as 'TBD' as black, instead they still come in as green. How do I layout my expression that actual percentages still come through as a color and all 'TBD's come in as black? My current expression is below.

=if(percent > 0 ,green(),
if(percent <= -.05, rgb(255,0,0),
if(percent >-.05 and percent <= 0,rgb(255,205,3),
if(percent = 'TBD',black()))))

Thanks!

Re: Text Color Expression

bharathadde — Fri, 13 Dec 2019 19:14:27 GMT

=if(Percent = 'TBD',black(),if(percent > 0 ,green(),
if(percent <= -.05, rgb(255,0,0),
if(percent >-.05 and percent <= 0,rgb(255,205,3),
))))

topic Re: Text Color Expression in QlikView

Text Color Expression

Re: Text Color Expression