Background color on Pivot table

[boopeshj]

Hello experts,

One challenge on pivot table.
I have a dimension month year with a conditional background color. When it is in rows the background color works fine [screenshot 2]. But when moving it to columns the first and second month dont get the background color [screenshot1]. 

[Arthur_Fong]

Maybe try attaching your sample qvw?

I am doing fine with the same configs as yours:

My expression for background color at dimension:

=if(YearPeriod='201901',green(),Yellow())

[Brett_Bleess]

Boopesh, given Arthur was not able to replicate things, check that you are running the latest SR for the major release you are running, here is the list, so you can check, if you are behind, try updating to the current one below for your major release track and see if that fixes the problem or not:

11.20 SR19

12.10 SR11

12.20 SR9

12.30 SR3

12.40 SR1

Regards,
Brett

[boopeshj]

@Arthur_Fong Thanks. Will check again. 

[boopeshj]

Thanks @Brett_Bleess BrettBlees will keep you posted. 

[boopeshj]

@Arthur_Fong  and @Brett_Bleess 

When I do it on one dimension it works fine. 

When adding multiple dimension it doesnt work. Please see the screenshot of both scenarios below. 

[Brett_Bleess]

Boopesh, may have to attach a QVW on this one in order for someone to help you get to the bottom of things, but difficult to troubleshoot without that...  Does not have to be your actual app, just one that will show the issue, so folks can dig into the setup of things including the data model etc.

Regards,
Brett

[Arthur_Fong · Accepted solution]

This happens when i have null values in my dataset:

You might need to handle all null values by changing it to 0.

 

Be sure to uncheck suppress 0-values at presentation tab in chart properties.

Refer qvw attached as reference.

Thanks and regards,

Arthur Fong

[boopeshj]

@Arthur_Fong  That is exactly true when I uncheck suppress zero I do get the values.

But I don't want to show zero or null values on my pivot table. It just populates too many rows. Do you have any suggestions for that? 

[boopeshj]

Thanks @Brett_Bleess  , @Arthur_Fong has already shared the insights. Just wanting to still avoid all the zeros though. Trying for a workaround for the same.