Background Color Expression not working as expected in Pivot table

[jagan]

Hi All,

I am getting an issue in applying the Background color to a pivotted dimension (Branch in attached file). I am using below expression

in Background color expression, but it is working Branch values BR002 and BR003, I think this is because of all values in first record,

=Pick(Match(Branch, 'BR001', 'BR002', 'BR003'), Red(), Green(), Blue())

If I select Product X then all background colors are applying as expected since it has values for all Branches.

I think it is bug, please let me know if there is any solution or fix for this. 

Henric Cronström Josh Good please look into this issue.

Thanks in advance.

Regards,

Jagan.

[Anonymous]

Hi Jagan,

Did you have any response about this ? (BugID: 61584) Looks like it continues not working well.

Regards!

[apiguy]

I just had this problem and found a fix:

Uncheck Suppress Zero-Values on the Presentation tab.

I tried it in your file and it works.  My guess is that Qlik is formatting the dimension based on the first instance it is shown, and the expression is null in your case.  So when we don't suppress the 0's or nulls it successfully processes the formatting.

(note:  if you need to suppress the 0's, I found another workaround in my case where i could trap the nulls in my expression with an if statement, but the first solution is easier).