topic Re: colors in Pivot table in QlikView

colors in Pivot table

Thu, 26 Jul 2012 12:34:18 GMT

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

Re: colors in Pivot table

brenner_martina — Thu, 26 Jul 2012 13:22:03 GMT

Hi,

look at my attached example!?

Greetings from Munich

Martina

Re: colors in Pivot table

Thu, 26 Jul 2012 14:06:06 GMT

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

Re: colors in Pivot table

brenner_martina — Thu, 26 Jul 2012 14:21:31 GMT

Hi Bernd,

there is no difference, look at the example.

Greetings from Munich

Martina

Re: colors in Pivot table

swuehl — Thu, 26 Jul 2012 14:31:39 GMT

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),' ')

Re: colors in Pivot table

Thu, 26 Jul 2012 14:36:19 GMT

Hi Martina,

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

Bernd

Re: colors in Pivot table

Thu, 26 Jul 2012 14:48:18 GMT

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

Re: colors in Pivot table

swuehl — Thu, 26 Jul 2012 14:52:29 GMT

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

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

Re: colors in Pivot table

Thu, 26 Jul 2012 14:53:42 GMT

there is no check in presentation - populate missing cells.

and the box is gray - no input

Bernd

Re: colors in Pivot table

swuehl — Thu, 26 Jul 2012 21:25:59 GMT

Is option 'suppress missing' checked?

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

Re: colors in Pivot table

Fri, 27 Jul 2012 12:41:29 GMT

Thanks to all, table is running perfect

Bernd