Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
rofa84
Contributor II
Contributor II

Getting Cumulative Percentage from a breakdown of a field

Hello experts, 

I have items for 3 months and they are under same "month" field but grouped by April, May, June. 

Under each month, there are managers and there are employees under each manager. 

What I'm trying to do is getting percentage that accumulates from employees to manager then to  each month. 

Eventually totaling up to 100%.  

 

I can get the percentage breakdown of employees, but it doesn't accumulate accordingly. Also, The table sums all the items for all 3 months and gets the percentage which give me around 30% for each month.  I want sum of total items separately so it will give me total of 100% for each month but I can't figure out how.

Here is the expression that I used 

SUM([Item1])/Sum(total<Employees, Manager>Item1)

and there is the snapshot of part of my pivot table. Thank you for your help!

Untitled.jpg

 

5 Replies
Vegar
MVP
MVP

What happens if you add month as well as an exception in the totaling? Like this:

 

SUM([Item1])/Sum(total<Employees, Manager, Month>Item1)

Plees ekskuse my Swenglish and or Norweglish spelling misstakes
rofa84
Contributor II
Contributor II
Author

I already have tried that one too but it still gives me the same result
Channa
Specialist III
Specialist III

SUM([Item1])/Sum(total< Manager>,<Month>Item1)

Channa
Vegar
MVP
MVP

It could be something with your data that you missed mentioning.

Could you try to create a (simplified) sample app for us? It would make
it easier to understand your issue and l to help.

—Vegar
Plees ekskuse my Swenglish and or Norweglish spelling misstakes
rofa84
Contributor II
Contributor II
Author

This one give me and error. I don't think there should be a comma