topic Re: Percentage in pivot table in QlikView

Percentage in pivot table

Anonymous — Mon, 30 Nov 2015 10:56:52 GMT

I have two table and ,

in table , I have (Item) and (Quantity/Ton)

in table , I have (debit) and (credit)

>> The "Balance" = (debit - credit)

** the relation between this two tables is the date only.

-------------------------------------------------------

how can I calculate the Qty% and Qty*total Balance/Total Qty in qlikview using pivot table ?!!

every time I try I faced problem with duplicate in data.

sorry for bad English.

Regards,

Re: Percentage in pivot table

Gysbert_Wassenaar — Mon, 30 Nov 2015 12:56:47 GMT

[Qty%]: Sum([Quantity/Ton])/Sum(Total [Quantity/Ton])

[Total Balance]: rangesum( sum(total debit), -sum(total credit))

Qty*total Balance/Total Qty: sum([Quantity/Ton]) * [Total Balance] / sum(Total [Quantity/Ton])

And if that doesn't work that means I don't have enough information to make a good guess. In that case please post a small qlikview document that illustrates the problem.