topic Re: changing values with colours using IF statement error in QlikView

changing values with colours using IF statement error

Tue, 28 Feb 2017 06:34:44 GMT

Dear experts,

I am currently using an IF loop to change a certain value to green/red when a condition is met the expression I am currently using is:

if($(v%rev), green(), red())

the logic seems correct to me however I am getting weird values in the straight table seen in the attached picture.

I have also attached a qvw file for your reference.

Kind regards,

Royce Tang

Re: changing values with colours using IF statement error

dsharmaqv — Tue, 28 Feb 2017 06:44:36 GMT

You are using color at incorrect place

just expand the expression where you want to display the color by cliking + symbol and enter your expression in background color

if( $(v%rev) > 0, Green(), red())

This will resolve your issue

Re: changing values with colours using IF statement error

avinashelite — Tue, 28 Feb 2017 06:58:39 GMT

Where you need this red() and green() colors ? in the gauge ? if that the case then in the expression tab go to gauge setting > Define the segments and its values according to your need that should work..

Re: changing values with colours using IF statement error

rahulpawarb — Tue, 28 Feb 2017 07:00:13 GMT

Hello Royce,

I agree with Deepak! Changing the Background color of % rev. growth expression will fetch the desired results (refer attached application).

Regards!

Rahul