Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld online is next week! REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sagar_vij99
Creator
Creator

Calculating and Storing total for a Column

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

1 Solution

Accepted Solutions
sagar_vij99
Creator
Creator
Author

Worked great. This is what I was looking..

Thanks..!!

View solution in original post

4 Replies
vvvvvvizard
Specialist
Specialist

Try sum(NPT)/sum(Total NPT)

sunny_talwar

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)

sagar_vij99
Creator
Creator
Author

Worked great. This is what I was looking..

Thanks..!!

jmvilaplanap
Specialist
Specialist

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