topic Re: Show numbers as Percentage in Pivot Table in QlikView

Show numbers as Percentage in Pivot Table

vksthkkr — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Show numbers as Percentage in Pivot Table

qlikviewwizard — Fri, 06 Jul 2018 07:10:39 GMT

Hi,

Can you attach the sample data?

Re: Show numbers as Percentage in Pivot Table

olivierrobin — Fri, 06 Jul 2018 07:14:54 GMT

hello

try something like

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

Re: Show numbers as Percentage in Pivot Table

sushil353 — Fri, 06 Jul 2018 07:17:51 GMT

Hi,

You need to use aggr function to get the percentage.

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

HTH

Sushil

Re: Show numbers as Percentage in Pivot Table

dapostolopoylos — Fri, 06 Jul 2018 07:36:51 GMT

Check out the attached app.

Re: Show numbers as Percentage in Pivot Table

qlikviewwizard — Fri, 06 Jul 2018 08:50:51 GMT

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?

Re: Show numbers as Percentage in Pivot Table

dapostolopoylos — Fri, 06 Jul 2018 08:58:14 GMT

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.

Re: Show numbers as Percentage in Pivot Table

qlikviewwizard — Fri, 06 Jul 2018 09:01:50 GMT

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

Re: Show numbers as Percentage in Pivot Table

dapostolopoylos — Fri, 06 Jul 2018 10:40:29 GMT

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)

Re: Show numbers as Percentage in Pivot Table

vksthkkr — Fri, 06 Jul 2018 11:33:02 GMT

This is exactly what I was looking for.

Thanks a bunch for the example document!