topic Custom Dimension on Partial Sum in QlikView

Custom Dimension on Partial Sum

Anonymous — Mon, 23 May 2016 13:12:28 GMT

Hello,

I have a Format Problem on a partial Sum, because when i want to change the background or the fore color, it affect only the expression:

Pivot Table:

Custom Format Cell:

How can i manage that please ?

Thanks you in advance for your help.

Sébastien.

sunny_talwar — Mon, 23 May 2016 13:20:01 GMT

Can you try playing around with this?

UPDATE: not sure if it will do anything, but see if that helps

Anonymous — Mon, 23 May 2016 13:43:38 GMT

I tried, it affects all but not the Partial Sum 😕 :

sunny_talwar — Mon, 23 May 2016 13:48:52 GMT

Ya, it doesn't seem to be working for subtotal unfortunately.

Anonymous — Mon, 23 May 2016 13:50:37 GMT

Okay

marcus_sommer — Mon, 23 May 2016 13:52:44 GMT

You could color your partialsums with an attribut-expression (in each expression/dimension) like:

if(match(Dimensionality(), 0,1), green())

- Marcus

sunny_talwar — Mon, 23 May 2016 13:54:08 GMT

But you can use if statement with SecondaryDimensionality() to get this to work.

sunny_talwar — Mon, 23 May 2016 13:55:24 GMT

Marcus‌ I think he will need SecondaryDimensionality() here:

Pick(SecondaryDimensionality()) + 1, Green(), White())