topic How to set color for data in pivot table if there is missing symbols in QlikView

How to set color for data in pivot table if there is missing symbols

Peony — Thu, 26 Oct 2017 12:29:37 GMT

Hi everyone.

I need help. There is table with data where some rows are needed to be filled in different colors due to some conditions. And everything is OK till I've moved column "Ouat" into horizontal view.

Because of empty cells that appears I've loose color filling for the cell with year "2010".

How can I fix it and return color to "2010" cell ?

Table:

LOAD * INLINE [

Yr, Quat, Amount

2011, Q1, 12000,

2011, Q2, 15800,

2011, Q3, 1230,

2011, Q4, 1289,

2010, Q3, 9000,

2010, Q4, 125800];

Color conditions:

=if(Yr='2010',LightGray(),LightGreen())

Re: How to set color for data in pivot table if there is missing symbols

sunny_talwar — Thu, 26 Oct 2017 14:42:37 GMT

May be uncheck 'Suppress Zero-Values' on the presentation tab

Re: How to set color for data in pivot table if there is missing symbols

Peony — Fri, 27 Oct 2017 05:21:29 GMT

Oh! It really helps! Thank you much!

Re: How to set color for data in pivot table if there is missing symbols

Peony — Fri, 27 Oct 2017 08:03:33 GMT

I wonder, if there any possibility to keep 'Suppress Zero-Values' checked and also to keep row color?

Re: How to set color for data in pivot table if there is missing symbols

sunny_talwar — Fri, 27 Oct 2017 08:29:36 GMT

You can give a feel of 'Suppress Zero Value' checked by using this expression

Dual(If(Sum(Amount) <> 0, Sum(Amount), '-'), Sum(Amount))

But can't think of another way to do this where 'Suppress Zero Value' is checked