topic Re: Calculate the percentage with different groups in App Development

Calculate the percentage with different groups

djaykumar — Wed, 26 Jun 2019 17:00:10 GMT

Hi All,

I am having issue with Percentage calculation with different group elements.

Please find below my report

GroupName	SBU	Mod Amount
Sales	Commission	204,045,960
Sales	Customer Support	989,000,000
Sales	Manufacturing -Parts Export	56,702,200
Sales	Slim	1,511,273,500
Sales	Turnkey	830,075,000
Material Cost	Customer Support	-411,150,000
Material Cost	Manufacturing -Parts Export	-33,371,320
Material Cost	Slim	-1,049,064,100
Material Cost	Turnkey	-570,420,000

In the above report Client wants the percentage calculation ie., materialcost Customer Support (-411150000) divided by

sales Customer Support (989000000) and MaterialCost Manufacturing Parts Export (-33371320) divided by sales Manufacturing Parts Export (56702200) and so on...

And all the calculated Percentages will be displayed only in material cost respective fields and in sales fields it should show 0.

Please help me in this.

Regards,

Jay

Re: Calculate the percentage with different groups

sunny_talwar — Wed, 27 Mar 2019 13:44:06 GMT

Try this

Sum({<GroupName = {"Material Cost"}>} [Mod Amount])
/
Sum(TOTAL <SBU> {<GroupName = {"Sales"}>} [Mod Amount])

Re: Calculate the percentage with different groups

djaykumar — Wed, 27 Mar 2019 13:48:36 GMT

Hi Sunny,
Thanks for quick Reply
But I am getting 0 with the above code.
Please help me
Regards,
Jay

Re: Calculate the percentage with different groups

sunny_talwar — Wed, 27 Mar 2019 14:04:43 GMT

Seems like you have two spaces between Material and Cost... try this

Sum({<GroupName = {"Material  Cost"}>} [Mod  Amount])
/
Sum(TOTAL <SBU> {<GroupName = {"Sales"}>} [Mod  Amount])

This worked for me in QlikView

Re: Calculate the percentage with different groups

djaykumar — Thu, 28 Mar 2019 03:38:07 GMT

Hi Sunny,
Its working perfectly .
Thank you very much
Regards,
Jay