topic Re: Calculating and Storing total for a Column in QlikView

Calculating and Storing total for a Column

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

Hi All,

I am trying to calculate %share for an individual from same column, so Column NPT has no. of production hours. When i calculate % for A it will be sum(NPT)/sum(NPT). now the problem is it always show 100% whenever i select a person's name in filter and i understand the reason that it filters out other values as well. Is it possible to store total of NPT column separate and then i can use it to calculate percentage share of each individual..? Any help/suggestion will be appreciated.

eg,

Name,NPT

A,2

B,2

ideally share should be 50% for both but i am getting 100.

Thanks

Sagar

Re: Calculating and Storing total for a Column

vvvvvvizard — Mon, 10 Jul 2017 10:41:43 GMT

Try sum(NPT)/sum(Total NPT)

Re: Calculating and Storing total for a Column

sunny_talwar — Mon, 10 Jul 2017 11:16:44 GMT

May be like this

If you are in a chart and you want to ignore all your selections

Sum(NPT)/Sum(TOTAL {1} NPT)

or if you are in a chart and you want to ignore selection in just Name field

Sum(NPT)/Sum(TOTAL {<Name>} NPT)

Re: Calculating and Storing total for a Column

sagar_vij99 — Tue, 11 Jul 2017 04:22:14 GMT

Worked great. This is what I was looking..

Thanks..!!

Re: Calculating and Storing total for a Column

jmvilaplanap — Tue, 11 Jul 2017 08:24:45 GMT

Hi sagar.vij99

You must to mark the response of stalwar1 as correct. Then people will could check this solution if they have the same (or similar) problem.

Regards