topic Re: Calculate % in QlikView

Calculate %

vanderson009 — Thu, 10 May 2018 14:43:28 GMT

I have below formatted data and i want to percentage that are based on year.

Example - ProductA contribution in 2016 is 20 and percentage of contribution would be 33.33 % for that year.

Thanks,

Villyee.

Re: Calculate %

adityaakshaya — Thu, 10 May 2018 14:56:44 GMT

Hi Villyee,

A quick question, are you looking to calculate the % within script or front end?

Re: Calculate %

vanderson009 — Thu, 10 May 2018 15:09:46 GMT

I am trying it at object level, means at front end lwvel.

Re: Calculate %

fvelascog72 — Thu, 10 May 2018 15:39:59 GMT

Hi,

Try with Sum(Sales)/Sum(TOTAL<Year> Sales)

Saludos

Re: Calculate %

isingh30 — Thu, 10 May 2018 15:47:39 GMT

Sum(Sales)/Sum(TOTAL<Year> Sales/100 )

Re: Calculate %

vvira1316 — Thu, 10 May 2018 15:59:12 GMT

I've got following

=Sum(Sales)/Aggr(Sum({<Year>} Sales), Year)

but I'm missing rows

Sunny stalwar1‌ or others can help here.

Re: Calculate %

sunny_talwar — Thu, 10 May 2018 16:13:06 GMT

May be this

=Sum(Sales)/Aggr(NODISTINCT Sum({<Year>} Sales), Year)

Re: Calculate %

vvira1316 — Thu, 10 May 2018 16:20:14 GMT

Yeah, that is correct. But the simple one mentioned by Ishtdeep will work.

I was having challenge as below

=Sum(Sales)/Sum( Total {<Year>} Sales) The curly braces for year were causing whole set sum. I didn't realize that curly braces for year were not required only angular were needed

Re: Calculate %

sunny_talwar — Thu, 10 May 2018 16:22:24 GMT

Yup

Re: Calculate %

sunny_talwar — Thu, 10 May 2018 16:23:39 GMT

Actually fvelascog72‌ was the first one to propose it and personally I would not multiply by 100 , but rather use number tab to show the expression as percentage

Re: Calculate %

isingh30 — Thu, 10 May 2018 16:38:02 GMT

Thanks Sunny for the feedback

Re: Calculate %

isingh30 — Thu, 10 May 2018 17:22:28 GMT

Thank you guys for your valuable inputs.All Credit goes to fvelascog72