Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

pivot tables with subtotals in dimensions

I have a pivot table with subtotals in different dimensions.

I select a predeterminate style for the pivot table and I see that perfectly with colors, but after I add other columns in the same pivot table and the subtotals of these columns don´t have the same color that the other columns <<Target Cost>>.

How can I solve it?

Thank you

5 Replies
marcus_sommer

Maybe you used several different layout-methods - the predefined styles intab design, visualizations from tab visualizations, formatting-conditions on dimension/expression-level (+ sign by each dimension/expression) and/or customize cell layouts (right click on a table-part and there about the mid) - and there is some inconsistency especially that these four methods have a different priorities.

- Marcus

Not applicable
Author

No I applied only the option predeterminate style for the pivot table and only one expression have a distinct color.

marcus_sommer

If only this predefined style is used it shouldn't be happens. Could you change the style and afterwards rechange again to your previous one?

- Marcus

Not applicable
Author

I do it but the expression the subtotals of these columns don´t have the same color that the other columns

marcus_sommer

Then the pivot might be corrupt and needs to be new created (new object, choose dimension, copy+paste from labels and expressions and so on - maybe with notepad as intermediate step). But before make sure that there is really no other layout applied (it might be created a long time ago and forgotten now).

- Marcus