Dual if function in Qliksense

[ToinkToinkTigger]

Hello there,

I have been playing around with if functions to change the background color of fields in my dashboard. Strangely enough this is working for 3 if statements:

if(Scope='GREEN',RGB(152,251,152),if(Scope='ORANGE',RGB(255,215,0),if(Scope='RED',RGB(240,128,128))))

However,

I cant seem to get this right for 2 if statements.

Can someone show me how to set this up for 2 if conditions within one sentence?

Thanks in advance,

[Or]

if(Scope='GREEN',RGB(152,251,152),if(Scope='ORANGE',RGB(255,215,0)))

Though in this sort of scenario, you might want to consider using Match() instead of several if() statements.

[ToinkToinkTigger]

Hey thanks,

Why should one use Match() instead of several if() statements?

How would that look in this case?

[Or]

Pick(Match(Scope,'GREEN','ORANGE'),RGB(152,251,152),RGB(255,215,0)) for example.

You can match as many values as you want and it comes out a lot cleaner than writing a bunch of nested if() statements, at least in my opinion (though nested if() statements will also work).

[ToinkToinkTigger]

Cheers! Thanks for your help

[rudesingh56]

Thanks for your help  get-vidmateapp.com

mobdro download