topic Re: Colour in QlikView

Colour

smilingjohn — Mon, 09 Nov 2015 06:52:07 GMT

Hi All,

I am trying to show a guage chart with an expression like sum(score)

and under background iam adding If(Sum(Score)<=500,Red(),Sum(Score)=Blue()).

Please find the attachment of qvw file its not working

Can someone help me please...

tamilarasu — Mon, 09 Nov 2015 06:53:27 GMT

Try the below one,

If(Sum(value)<=1000,Green(),Red())

tamilarasu — Mon, 09 Nov 2015 07:27:26 GMT

Hi John,

Did you edit the question again.? Seems your thread has been changed.

For the above scenario, the expression should be

If(Sum(Score)<=500,Red(),Blue())

smilingjohn — Mon, 09 Nov 2015 07:54:07 GMT

its not working Nagraj.

avinashelite — Mon, 09 Nov 2015 08:01:00 GMT

check the attachment for the solution, you need to fix the lower and upper bound to display the color .

first un-check the Autowidth segment option in the Presentation and then fix the lower and upper bound accordingly

Anonymous — Mon, 09 Nov 2015 08:04:55 GMT

What exactly you want?

tamilarasu — Mon, 09 Nov 2015 08:16:28 GMT

Or You can check the attachment.

smilingjohn — Mon, 09 Nov 2015 08:21:27 GMT

Thanks Nagraj