Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
New Contributor III

dynamic subtotal

I've got a very simple pivot table with a grafic classification of the expression "importo totale" with 8 colours. (file trial)

How can I've a sub-total of difference colours ?



2 Replies

Re: dynamic subtotal

I suggest you creates within the script an additionally main-category to your sub-category and used then the partial-sum feature from the pivot-table. If this isn't suitable you could also create a Calculated Dimensions.

- Marcus

Valued Contributor

Re: dynamic subtotal

You can change the formatting of the cells, depending on the aggregation level, using DIMENSIONALITY() function.

Go to Expressions, expand the expression and change the "Background color" to something like:

=if(Dimensionality() = 1, red(), Blue())

Community Browser