colors in Pivot table

[#1]

I want to have different colors in my pivot table background.

As you see in the sample, system does it well, when
there are values in all cells. If there are no values, cells as well as
dimensions do not have colors.

I defined background color with
if(Division='A', lightblue(050), lightblue(100))

I did apped my sample .qvw

Who can help me with this?

Bernd

my testscript is very simple:

load *
INLINE [
Company, Division, Month, Sales
company 1, A, 01, 10
company 1, A, 02, 13
company 1, A, 03, 13
company 1, A, 04 ,17
company 1, A, 05, 12
company 1, A, 06, 21
company 1, B, 01, 10
company 1, B, 02, 16
company 1, B, 03, 17
company 1, B, 04 ,19
company 1, B, 05, 13
company 1, B, 06, 14
company 2, B, 02, 10
company 2, B, 03, 20
company 2, B, 05, 15
company 2, A, 02,10
];

second example with avg-function

Nachricht geändert durch Bernd Haak

[brenner_martina]

Hi,

look at my attached example!?

Greetings from Munich

Martina

[#3]

Hi Martina,

very good, but in my final table it does not work, because I do not have a sum-funktion, but an avg-function. Do you have a solution also for avg?

Bernd

[brenner_martina]

Hi Bernd,

there is no difference, look at the example.

Greetings from Munich

Martina

[swuehl]

Martina, I think there is a difference if you only use the expression with the avg().

But you can use the sum(Sales) for the test:

=if(sum(Sales)<>0,avg(Sales),' ' )

or I think it would be more accurate to use a test on NULL:

=if(not isnull(Sales),avg(Sales),' ')

[#6]

Hi Martina,

you have now a sum and an avg, so the sum-function gives the value. Please try only with avg

Bernd

[#7]

swuehl and Martina,

thanks to both. in the sample, it does run well, but in my origin .qvw it still doesn't. I have to check the differences.

Bernd

[swuehl]

Are your fields located in different tables? Maybe you encounter something similar to

http://community.qlik.com/message/239099#239099

[#9]

there is no check in presentation - populate missing cells.

and the box is gray - no input

Bernd

[swuehl · Accepted solution]

Is option 'suppress missing' checked?

If so, you need to uncheck that option first, this should activate 'populate missing cells', then check this option.