Multiple If statement not working

EashwarBalaji — Wed, 19 Apr 2023 15:02:37 GMT

Hi, I'm trying to fill the background color of the following pivot table on Qlik using some conditions.

Important fields: Submitted Month, Month Due and Area

Image 1:

PS: Apologies, had to redact some info due to security reasons.

Conditions:

Red - If Submitted Month <> Month Due (Irrespective of the Area)
If Submitted Month = Month Due, then
1. Green - If Area = "A"
2. Blue - If Area = "B"
3. Else Yellow

I tried IF([Submitted Month]<>[Month Audit Due],Red(),Green()) to check my if statement is working fine, it colored all the values to green except where Submitted Month <> Month, which was in red as expected [Ref Image 2 below].

Image 2:

But when I add the rest of my if statement, none of the cells were colored (as shown in Image 1 above). This is the formula I used:

=IF([Submitted Month]<>[Month Audit Due],Red(),IF([Area]="A",Green(),IF([Area]="B",Blue(),Yellow()))

Can you please help me solve this issue. Thanks in advance.

Re: Multiple If statement not working

EashwarBalaji — Thu, 20 Apr 2023 10:39:17 GMT

Not sure if this is a technical constraint or not, but equating columns to a static text is not working. Let me explain.

I created two variables on QlikSense with the name vA and vB with values A and B respectively and used the following statement in background expression:

=IF([Submitted Month]<>[Month Audit Due],Red(),IF([Area]=vA,Green(),IF([Area]=vB,Blue(),Yellow())))

It works perfectly fine now.

topic Multiple If statement not working in QlikView

Multiple If statement not working

Re: Multiple If statement not working