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

Announcements
Qlik Connect 2026! Turn data into bold moves, April 13 -15: Learn More!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to use Total<> for 100% when I change dimension position

error loading image

error loading image

Hello,

How can I use total<> , when I allow pivot in pivot table and the % total still show 100% like in pic1

(but now this table show like pic2)

and code >>>> total<Cyclicgroup>

(Cyclicgroup = PP, BBB, TTT)

Many thanks

10 Replies
Not applicable
Author

For all excel sheets are what I try to do in one table.

Because I allow pivot but I want to show all % in blue cell = 100%.

So I' m try to do dinamic total %FRT