topic Re: assigning color to text object in QlikView

assigning color to text object

apthansh — Wed, 25 Nov 2020 16:16:04 GMT

if(Location='NewYork' ,

if([Score] >=11 ,green(),

if([Score] <=11 ,yellow(),

if([Score] =0,red()))))

Can I use the above expression to assign colors to text objects ?

Re: assigning color to text object

sunny_talwar — Tue, 21 Nov 2017 19:46:53 GMT

This will work only if there is only one possible Location and Score are there? If you have more than one option for either of them, it might not work

Re: assigning color to text object

apthansh — Tue, 21 Nov 2017 19:58:13 GMT

Ya...I have more locations..How can i resolve that ?

Re: assigning color to text object

woshua5550 — Wed, 22 Nov 2017 11:50:03 GMT

Hi Ansh

plz explain more , let's say we have three locations "New York","London","Beijing"

what color would you like to show when user select more than 1 location , for example "New York"&"London"?

Re: assigning color to text object

sunny_talwar — Wed, 22 Nov 2017 12:11:24 GMT

May be this

If(Only({<Location *= {'NewYork'}>} Location) = 'NewYork',

If(Only({<Location *= {'NewYork'}>}[Score]) = 0, Red(),

If(Only({<Location *= {'NewYork'}>}[Score]) <= 11, Yellow(), Green())))