Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

escarber
New Contributor

Change Value in a table

I use Qliksense Desktop.  I have a filed called Meet Gap and I need to change the color based on the value.  If it is 'yes' then green else if it is 'no' then red.  I tried the if statements but the values shows are RGB(128,0,0) not no

5 Replies
reddys310
Honored Contributor II

Re: Change Value in a table

Hi Ed,

You need to make use the Meet Gap is used as a dimension in the visualisation :

Try this expression:

if ([Meet Gap] = 'yes',rgb(146,208,80),rgb(225,0,0))

Best Regards,

Sangram

escarber
New Contributor

Re: Change Value in a table

When I do that the rgb values show up and not the color.  I am using QlikSense Desktop

escarber
New Contributor

Re: Change Value in a table

That did not work on a table.  It actually displays the RGB.

reddys310
Honored Contributor II

Re: Change Value in a table

Hi Ed,

Is it possible to share a qvf file?

Thanks,

Sangram

paul_scotchford
Valued Contributor

Re: Change Value in a table

The expression Sangram supplied you is correct, dare I venture the question , did you add this to the

Text Color expression attribute of your field in the table ?

TxtColor.png

Community Browser