Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
On Demand Webinar: See Why Thousands of QlikView Users Have Switched to Qlik Sense. REGISTER
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

1 Solution

Accepted Solutions
vinieme12
Champion II
Champion II

use the TOTAL Keyword

SUM(TOTAL <Contno> Cost )   / Sum(TOTAL <Contno> Sales)

What does the TOTAL qualifier do?

When should the Aggr() function NOT be used?

View solution in original post

13 Replies
qlikview979
Specialist
Specialist

Hi  are you expecting like this

Untitled.png

sekharQV
Creator
Creator

Hi Mahesh,

Thanks for reply.

I am expecting the result as shown in attached excel.

and one more point is i am showing unit no in  report. but result should be displayed based on associated units for a contract.

I have month-year dimension also in my report, so contract no's will be repeated for month-&year

Regards,

Rajasekhar.

qlikview979
Specialist
Specialist

Are u Untitled.png

Expecting like this

qlikview979
Specialist
Specialist

Hi,

PFA

Frank_Hartmann
Master II
Master II

see attached file.

hope this helps

vinieme12
Champion II
Champion II

use the TOTAL Keyword

SUM(TOTAL <Contno> Cost )   / Sum(TOTAL <Contno> Sales)

What does the TOTAL qualifier do?

When should the Aggr() function NOT be used?

View solution in original post

sekharQV
Creator
Creator

No Mahesh,

Please refer attached excel. I need result(%CoEst) as shown in attached excel. I explained logic in Column F.


Please have a look and let me know your ideas.

Regards,

Rajasekhar

sekharQV
Creator
Creator

Hi,

If if possible can you me expression here? I can open file only on Monday at offc.

Thanks,

Sekhar

sekharQV
Creator
Creator

Hi Frank,

If if possible can you me expression here? I can open file only on Monday at offc.

Thanks,

Sekhar