Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
kitjupitera
Contributor

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

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

Tags (1)
1 Solution

Accepted Solutions

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

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

Capture.PNG

4 Replies

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

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

Capture.PNG

kitjupitera
Contributor

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

Oh! It really helps! Thank you much!

kitjupitera
Contributor

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

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

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

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

Capture.PNG

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

Community Browser