Calculate Percentage based on range of associted values

[sekharQV]

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

[qlikview979]

Hi  are you expecting like this

[sekharQV]

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]

Are u

Expecting like this

[qlikview979]

Hi,

PFA

[Frank_Hartmann]

see attached file.

hope this helps

[vinieme12 · Accepted solution]

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?

[sekharQV]

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]

Hi,

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

Thanks,

Sekhar

[sekharQV]

Hi Frank,

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

Thanks,

Sekhar