topic Re: how to apply background color using multiple if statement in QlikView

how to apply background color using multiple if statement

Mon, 27 Jul 2015 14:21:10 GMT

How to write an expression in QlikView for multiple if.

If(budget=1,back ground color green)if (budget=2,background color orange,if budget=3,back ground color red)

pls suggest

Re: how to apply background color using multiple if statement

manideep78 — Mon, 27 Jul 2015 14:22:51 GMT

if(budget=1, green,

if(budget =2, orange,

if(budget=3, red)))

Re: how to apply background color using multiple if statement

Anonymous — Mon, 27 Jul 2015 14:22:54 GMT

if(budget=1, back ground color green, if (budget=2, background color orange, if (budget=3,back ground color red)))

Re: how to apply background color using multiple if statement

robert_mika — Mon, 27 Jul 2015 14:27:27 GMT

=if(budget=1, green(), if(budget =2, rgb(255,128,64),if(budget=3, red())))

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: how to apply background color using multiple if statement

awhitfield — Mon, 27 Jul 2015 15:03:56 GMT

Hi ipsita,

worked example attached!

HTH - Andy

Re: how to apply background color using multiple if statement

engishfaque — Mon, 27 Jul 2015 15:40:50 GMT

Dear Ipsita,

There are 3re ways to apply background colors,

1st Way: Please note, there is no orange color function into QlikView. Therefore, Orange color will not work and you have to use color code such as, mentioned in 2nd Way:

=If (budget = 1, Green(),

If (budget = 2, Orange(),

If (budget = 3, Red())))

2nd Way:

=If (budget = 1, RGB(0,255,0),

If (budget = 2, RGB(255,153,0),

If (budget = 3, RGB(255,0,0))))

3rd Way: (Best way for big projects)

Create variables for each color and use them where you need, such as given below:

Settings > Variable Overview > Add > variableName ( ex. vColorGreen ) > Select Variable > Give value into variable Definition ( ex. RGB(0,255,0) )

vColorGreen = RGB(0,255,0)

vColorOrange = RGB(255,153,0)

vColorRed = RGB(255,0,0)

=If (budget = 1, $(vColorGreen),

If (budget = 2, $(vColorOrange),

If (budget = 3, $(vColorRed))))

Kind regards,

Ishfaque Ahmed

Re: how to apply background color using multiple if statement

Mon, 27 Jul 2015 16:05:26 GMT

Thank u Ahmed.It worked..