Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
sinhanima
Contributor
Contributor

% of totals - Pivot table

I have following table in Qlik, and i want to get % of Total based Monthly column totals for each Area of focus (yellow).

The formula i have right now is = sum(Missed Lines)/sum(<total> Missed Lines), but it is giving me % based entire table's total value. How can i acheive % based on Total values of Columns.

Year2021
Fiscal MonthOCT NOV DEC 
Area of FocusMissed Lines% Of Total Missed LinesMissed Lines% Of Total Missed LinesMissed Lines% Of Total Missed Lines
Totals972100.00%639100.00%695100.00%
A10711.01%487.51%304.32%
B33934.88%30046.95%33548.20%
C868.85%477.36%456.47%
D22823.46%10716.74%15422.16%
E21221.81%13721.44%13118.85%
Labels (1)
4 Replies
Ksrinivasan
Specialist
Specialist

hi,

find the example with DIM and Measures

Ksrinivasan_0-1611249459858.png

ksrinivasan

sinhanima
Contributor
Contributor
Author

Thanks Ksrinivasan,  I have used exact same formula but this formula works when i don’t have months and years in columns. How can I make it work when Months/years or any other dimensions are used as column dimensions? 
 

Ksrinivasan
Specialist
Specialist

Hi sinhanima,

my dummy data

Ksrinivasan_0-1611254655065.png

 

table with %

Ksrinivasan_1-1611254770619.png

 

ksrinivasan

 

 

sinhanima
Contributor
Contributor
Author

For this solution i will need to call out (use set expressions) for each Cat as different  measures, and if I introduce months or years or weeks in the columns, this solution will create multiple columns ( ex: 12 months X 5 different CAT X 2 different measures). 

also as the number of CAT increases or data gets added for more number of months/years this will only create endless number of columns.