topic Change Value in a table in App Development

Change Value in a table

Anonymous — Tue, 26 Jan 2016 16:37:56 GMT

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

Re: Change Value in a table

reddy-s — Tue, 26 Jan 2016 19:08:20 GMT

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

Re: Change Value in a table

Anonymous — Thu, 28 Jan 2016 13:00:02 GMT

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

Re: Change Value in a table

Anonymous — Thu, 28 Jan 2016 15:05:56 GMT

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

Re: Change Value in a table

reddy-s — Thu, 28 Jan 2016 23:32:33 GMT

Hi Ed,

Is it possible to share a qvf file?

Thanks,

Sangram

Re: Change Value in a table

paul_scotchford — Fri, 29 Jan 2016 01:53:20 GMT

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 ?