topic Re: Background color on Pivot table in QlikView

Background color on Pivot table

boopeshj — Sat, 16 Nov 2024 20:08:22 GMT

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

Re: Background color on Pivot table

Arthur_Fong — Thu, 05 Sep 2019 08:33:12 GMT

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

Re: Background color on Pivot table

Brett_Bleess — Wed, 18 Sep 2019 14:46:12 GMT

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

Re: Background color on Pivot table

boopeshj — Mon, 07 Oct 2019 13:34:19 GMT

@Arthur_Fong Thanks. Will check again.

Re: Background color on Pivot table

boopeshj — Mon, 07 Oct 2019 13:34:49 GMT

Thanks @Brett_Bleess BrettBlees will keep you posted.

Re: Background color on Pivot table

boopeshj — Fri, 25 Oct 2019 13:21:06 GMT

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

Re: Background color on Pivot table

Brett_Bleess — Mon, 28 Oct 2019 20:03:35 GMT

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

Re: Background color on Pivot table

Arthur_Fong — Tue, 29 Oct 2019 01:01:43 GMT

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

Re: Background color on Pivot table

boopeshj — Thu, 31 Oct 2019 08:42:13 GMT

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

Re: Background color on Pivot table

boopeshj — Thu, 31 Oct 2019 08:44:11 GMT

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.

Re: Background color on Pivot table

Arthur_Fong — Thu, 31 Oct 2019 08:48:36 GMT

You might need to change to straight table to avoid color issues and also be able to suppress zero values.