topic Re: Expression in QlikView

Expression

Anonymous — Mon, 30 Nov 2015 11:14:41 GMT

How can I using this expression with right way:

( Qty * sum(Balance) ) / (sum (Qty)

I have table contain Item, Qty and Balance.

jonathandienst — Mon, 30 Nov 2015 11:16:33 GMT

Perhaps this (weighted average):

Sum(Qty * Balance) / Sum(Qty)

sunny_talwar — Mon, 30 Nov 2015 11:17:04 GMT

May be this:

Sum(Balance * Qty)/Sum(Qty)

Anonymous — Mon, 30 Nov 2015 12:18:14 GMT

Sorry, I explain it with wrong way

I need to make percentage for each Quantity >>> single quantity / total quantity

= Qty / sum(Qty)

arulsettu — Mon, 30 Nov 2015 12:19:49 GMT

try this

sum(Qty)/sum(Total Qty)

Anonymous — Mon, 30 Nov 2015 12:21:01 GMT

still not clear, what exactly you want??

Anonymous — Mon, 30 Nov 2015 12:22:17 GMT

if it is for QTY only then try like:

=Sum(QTY)/Sum(<Total> QTY)

Kushal_Chawda — Mon, 30 Nov 2015 12:24:27 GMT

try below expression

num(sum(Qty)/ sum(Total <Item>Qty),'#.00%')

Anonymous — Mon, 30 Nov 2015 12:26:25 GMT

I put the QV Example to be clearly