Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

prasad_dumbre
Contributor

Calculation of Share% in Pivote

Dear All,

I have attached sample .QVW with data, In this I want find contribution of each category with respect to total.

So, in Layman term formula is: Amount/Total Amount.

Can you please guide me how to do this . . .

Thanks in advance . . .

1 Solution

Accepted Solutions
qlikpahadi07
Valued Contributor

Re: Calculation of Share% in Pivote

Hi Prasad,

I think you need a Contribution with Weeks

Sum / Total is like

sum(Amount)/sum(TOTALAmount)

and if you add few more Dimensions just add this

sum(Amount)/sum(TOTAL <Week> Amount)

i think this might help you  find the attachment

Cheers!!!!

3 Replies
jonbrough
Valued Contributor

Re: Calculation of Share% in Pivote

I assume you mean the total of each week. Please find attached if that is the case.

Jonathan

qlikpahadi07
Valued Contributor

Re: Calculation of Share% in Pivote

Hi Prasad,

I think you need a Contribution with Weeks

Sum / Total is like

sum(Amount)/sum(TOTALAmount)

and if you add few more Dimensions just add this

sum(Amount)/sum(TOTAL <Week> Amount)

i think this might help you  find the attachment

Cheers!!!!

prasad_dumbre
Contributor

Re: Calculation of Share% in Pivote

Thank you Rohit & Jon , for such quick reply . . .

Community Browser