topic Re: Dual if function in Qliksense in App Development

Dual if function in Qliksense

ToinkToinkTigger — Mon, 04 Jul 2022 14:38:21 GMT

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,

Re: Dual if function in Qliksense

Or — Mon, 04 Jul 2022 16:27:56 GMT

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.

Re: Dual if function in Qliksense

ToinkToinkTigger — Tue, 05 Jul 2022 08:18:35 GMT

Hey thanks,

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

How would that look in this case?

Re: Dual if function in Qliksense

Or — Tue, 05 Jul 2022 08:27:23 GMT

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).

Re: Dual if function in Qliksense

ToinkToinkTigger — Tue, 05 Jul 2022 08:51:05 GMT

Cheers! Thanks for your help

Re: Dual if function in Qliksense

rudesingh56 — Wed, 06 Jul 2022 18:39:12 GMT

Thanks for your help get-vidmateapp.com

mobdro download