topic Colouring cells in pivot table in QlikView

Colouring cells in pivot table

Thu, 23 Jul 2009 22:36:42 GMT

I am colouring the background of a dimension in a pivot table with the following expression;

=if(Migrated<>'Yes',rgb(255,00,00),rgb(0,255,0))

basically for values of Yes i want the dimension green and for no i want them red.

This works ok but it colours the totals in red.

Can i stop the totals row from getting colour applied?

Could i change my expression, or is there another way?

Colouring cells in pivot table

disqr_rm — Thu, 23 Jul 2009 23:08:33 GMT

Try:

=if(Migrated = 'Yes',rgb(0,255,0), if(Migrated = 'No', rgb(255,0,0)))

Colouring cells in pivot table

Fri, 07 Aug 2009 15:17:48 GMT

Tried that it didn't help, totals still get coloured red.

Is there some expression i could use to tell if it is a totals row?

Steve

Colouring cells in pivot table

Fri, 07 Aug 2009 15:46:10 GMT

This is better,

=if(count(Migrated)>1,White(), if(Migrated = 'Yes', RGB(0,200,0), RGB(200,0,0)))

but still colours totals row if count=1.

There must be a better way of telling if we are on a totals row.

Colouring cells in pivot table

Fri, 07 Aug 2009 16:20:59 GMT

I'm a little bit confused but why don't you use the propoerties dialogue of the pivot table to define your coloring? I have a pivot table where every row represents data of a formula. In the visualize dialogue of the pivot table's propoerties, you can define the coloring of each and every row. So if I don't want to color a specific table row's values, I simply don't define the coloring.

Isn't that working for you?

Colouring cells in pivot table

Fri, 07 Aug 2009 16:26:07 GMT

I'm using qlikview 8.2. There is no visualize tab in the pivot table properties. There is a visual Cues, but that only shows expressions not dimensions.

Colouring cells in pivot table

johnw — Sat, 08 Aug 2009 01:09:51 GMT

I believe you want to check the dimensionality() value. From the help text:

"dimensionality ( )

Returns the number of dimension columns that have non-aggregation content. i.e. do not contain partial sums or collapsed aggregates.

A typical use is in attribute expressions, when you want to apply different cell formatting depending on aggregation level of data.

This function is only available in charts. For all chart types except pivot table it will return the number of dimensions in all rows except the total, which will be 0."