Discussion Board for collaboration on QlikView Scripting.
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 ?
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.
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())