customize Pivot table

[vengadeshpalani]

Hi all,

i have pivot table like below but i need to show extra one row with blue color based on Dim-3 how can i achieve this requirement?

Actual

what we need

please give some idea...

[sunny_talwar]

Of course... I am not thinking straight.. try this

Dim3

=Pick(ExtraDim, if([FINANCIAL PLAN]<>'ZZZZZ',[FINANCIAL PLAN]), ' ')

Dim3 color

=If(Only({1} ExtraDim) = 2, LightBlue())

expression

Pick(ExtraDim, (if ([FINANCIAL PLAN] <>'ZZZZZ', SUM(AMOUNT),0)), 0)

expression color

=If(Only({1} ExtraDim) = 2, LightBlue())

[vengadeshpalani]

[vengadeshpalani]

it's not working Sunny.values are showing as null

[sunny_talwar]

Can you share what you have?

[vengadeshpalani]

the issue is if anyone of month column is null means it applies color

Root cause --> if the total value is zero or null means we want to apply color.

is it possible in Pivot Table? 

[vengadeshpalani]

How to apply total value in all month Dim value?

[jonathandienst]

The problem is that the cell is probably not null, but missing. Missing values are never calculated, so the colour expression cannot fix the problem. The solution could be to backfill the missing values with zeroes or nulls.

NULL handling in QlikView

The Importance of Nothing