Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Make your voice heard! Participate in the 2020 Wisdom of Crowds® Survey. BEGIN SURVEY
Highlighted
Partner
Partner

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

1 Solution

Accepted Solutions
Highlighted
Partner
Partner

Re: Background color on Pivot table

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
Highlighted
Partner
Partner

Re: Background color on Pivot table

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())

Highlighted
Digital Support
Digital Support

Re: Background color on Pivot table

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
Partner
Partner

Re: Background color on Pivot table

@Arthur_Fong Thanks. Will check again. 

Highlighted
Partner
Partner

Re: Background color on Pivot table

Thanks @Brett_Bleess BrettBlees will keep you posted. 

Highlighted
Partner
Partner

Re: Background color on Pivot table

@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

Highlighted
Digital Support
Digital Support

Re: Background color on Pivot table

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 don't forget to use the "Accept as Solution" button on any posts that helped you resolve your problem or question.
Highlighted
Partner
Partner

Re: Background color on Pivot table

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

Highlighted
Partner
Partner

Re: Background color on Pivot table

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

Highlighted
Partner
Partner

Re: Background color on Pivot table

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.