topic Re: Help in Formula - Gauge Light in QlikView

Help in Formula - Gauge Light

Thu, 30 Jul 2015 13:10:03 GMT

Hi friends,

For display of traffic gauge lights, i am using the formula where

0 - Green

1-Amber

2-Red

=If((Column(3)/Column(2))*100 < '0%','0',If((column(3)/column(2))*100 > '0%' and (column(3)/column(2)) < '5%','1','2'))

But when the condition is 0%, it should show green but it is showing red.

Can someone help me with formula?

Regards,

Re: Help in Formula - Gauge Light

awhitfield — Thu, 30 Jul 2015 13:11:34 GMT

Can you upload your qvw?

Andy

Re: Help in Formula - Gauge Light

Thu, 30 Jul 2015 13:14:20 GMT

Hey Andy, Sorry but i can't

Will post something very similar that will help you to understand.

Regards,

Re: Help in Formula - Gauge Light

robert_mika — Thu, 30 Jul 2015 13:14:49 GMT

Try to take of all '

=If((Column(3)/Column(2))*100 < 0,0,If((column(3)/column(2))*100 => 0 and (column(3)/column(2)) < 5,1,2))

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: Help in Formula - Gauge Light

jonathandienst — Thu, 30 Jul 2015 13:16:03 GMT

This will fix your expression:

=If((Column(3) / Column(2)) * 100 < 0, 0,

If((Column(3) / Column(2)) < 0.05, 1, 2))

But how are you getting from there to the colours RAG?

Re: Help in Formula - Gauge Light

Anonymous — Thu, 30 Jul 2015 13:19:38 GMT

why are you using % .. by default QV returns in numbers have you specified anywhere to return in percent ?

use

=If((Column(3)/Column(2))*100 < 0,0,If((column(3)/column(2))*100 > 0 and (column(3)/column(2)) < 5,1,2))

Thanks

BKC

Re: Help in Formula - Gauge Light

sunny_talwar — Thu, 30 Jul 2015 13:20:29 GMT

all other colors are working fine for you?

Re: Help in Formula - Gauge Light

Thu, 30 Jul 2015 13:32:57 GMT

Hi,

All Rag's colors are working fine except for one. Posting an excel sheet with details.

Hope that will help.

Regards,

Re: Help in Formula - Gauge Light

Anonymous — Thu, 30 Jul 2015 13:36:38 GMT

Try this please:

=If((Column(3)/Column(2))*100 <= '0','0',If((column(3)/column(2))*100 > '0' and (column(3)/column(2)) < '5','1','2'))

Re: Help in Formula - Gauge Light

Thu, 30 Jul 2015 13:38:39 GMT

If i simply use =(Column(3)/Column(2)) for calculation of Column 4, i am getting dash

So if column 3 = 0 and column 2 = 0

then column 4 will be 0% or - should return green color not red.

Am i making sense? Anything more than 5% should be red.

Regards,

Re: Help in Formula - Gauge Light

jonathandienst — Thu, 30 Jul 2015 13:44:11 GMT

=If(Column(3) / Column(2) < 0 Or Column(2) = 0, 0,

If(Column(3) / Column(2) < 0.05, 1, 2))

Re: Help in Formula - Gauge Light

Thu, 30 Jul 2015 15:40:42 GMT

Thanks all