Multiple If statement not working

[EashwarBalaji]

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:

1. Red - If Submitted Month <> Month Due (Irrespective of the Area)
2. 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.

[EashwarBalaji · Accepted solution]

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.