Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
Leverage your QlikView investment to modernize BI – see how! Join Group
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Custom Dimension on Partial Sum

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:

Capture.PNG

Custom Format Cell:

Capture.PNG

How can i manage that please ?

Thanks you in advance for your help.

Sébastien.

7 Replies
Highlighted

Re: Custom Dimension on Partial Sum

Can you try playing around with this?

Capture.PNG

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

Highlighted
Creator
Creator

Re: Custom Dimension on Partial Sum

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

Capture.PNG

Highlighted

Re: Custom Dimension on Partial Sum

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

Highlighted
Creator
Creator

Re: Custom Dimension on Partial Sum

Okay

Highlighted
MVP & Luminary
MVP & Luminary

Re: Custom Dimension on Partial Sum

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

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

- Marcus

Highlighted

Re: Custom Dimension on Partial Sum

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

Highlighted

Re: Custom Dimension on Partial Sum

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

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