Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
boopeshj
Partner - Creator II
Partner - Creator II

Background color on Pivot table

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

clipboard_image_0.png

 

clipboard_image_1.png

Labels (2)
1 Solution

Accepted Solutions
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

This happens when i have null values in my dataset:

MC.PNG

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

MC2.PNG 

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

Refer qvw attached as reference.

 

Thanks and regards,

Arthur Fong

 

 

View solution in original post

10 Replies
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

Maybe try attaching your sample qvw?

I am doing fine with the same configs as yours:

clipboard_image_1.png

My expression for background color at dimension:

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

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
boopeshj
Partner - Creator II
Partner - Creator II
Author

@Arthur_Fong Thanks. Will check again. 

boopeshj
Partner - Creator II
Partner - Creator II
Author

Thanks @Brett_Bleess BrettBlees will keep you posted. 

boopeshj
Partner - Creator II
Partner - Creator II
Author

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

Pivot bgcolor.jpg

Brett_Bleess
Former Employee
Former Employee

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

To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question.
I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.
Arthur_Fong
Partner - Specialist III
Partner - Specialist III

This happens when i have null values in my dataset:

MC.PNG

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

MC2.PNG 

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

Refer qvw attached as reference.

 

Thanks and regards,

Arthur Fong

 

 

boopeshj
Partner - Creator II
Partner - Creator II
Author

@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
Partner - Creator II
Partner - Creator II
Author

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.