Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sekharQV
Creator
Creator

Calculate Percentage based on range of associted values

Hi All,

I want calculate percentage based on range of unitno's that are associated with contract number.

I have attached my sample excel file and QVW which will explain more better about my concern.

I used dummy data here and i am getting actual data from db.

Please have a look and help me.

Thanks & Regards,

Sekhar

13 Replies
Frank_Hartmann
Master II
Master II

See  Vineeth Pujari ´s  solution. I think this is what you are looking for!

qlikview979
Specialist
Specialist

Hi



It will exact output  please   check the attached file .

Anonymous
Not applicable

Hi,

Can you try this

Aggr(sum(Cost)/Sum(Sales),ContNo)

vinieme12
Champion III
Champion III

a good read

When should the Aggr() function NOT be used?

Vineeth Pujari
If a post helps to resolve your issue, please accept it as a Solution.