Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
vksthkkr
Contributor III
Contributor III

Show numbers as Percentage in Pivot Table

I have a pivot table that shows order numbers like this.

The expression is Sum(Order_Value)

I want to create another table that shows weekly numbers as % of total for each month. the representation (in Excel) looks like shown below

Need help with the expression that needs to be used to make this work

1 Solution

Accepted Solutions
dapostolopoylos
Creator III
Creator III

Check out the attached app.

Father/Husband/BI Developer

View solution in original post

9 Replies
qlikviewwizard
Master II
Master II

Hi,

Can you attach the sample data?

olivierrobin
Specialist III
Specialist III

hello

try something like

Sum(Order_Value)/Sum(total <month> Order_Value)

sushil353
Master II
Master II

Hi,

You need to use aggr function to get the percentage.

something like:  sum(Order_Value) / aggr(Total Sum(Order_Value),Month)

HTH

Sushil

dapostolopoylos
Creator III
Creator III

Check out the attached app.

Father/Husband/BI Developer
qlikviewwizard
Master II
Master II

What is the logic to show percentage in the second table?

It is not clear how you calculated? Can you explain how you got 16% for 2017-Apr for W-2?

dapostolopoylos
Creator III
Creator III

It's a pretty straight forward app.

It calculates the share of every week versus the total revenue by month...

It was what vikash asked for.

Father/Husband/BI Developer
qlikviewwizard
Master II
Master II

2017-Week1 :16+17+13=46 But your value is 45. How?

dapostolopoylos
Creator III
Creator III

Arjun,

being a level 9 forum member means that you can easily understand the calculations on the second table of my app and i find it weird that you want me to explain to you this calculation :

Sum(Revenue)/Sum(TOTAL<Year,Month>Revenue)

Father/Husband/BI Developer
vksthkkr
Contributor III
Contributor III
Author

This is exactly what I was looking for.

Thanks a bunch for the example document!