Expression Problem

andrea90casa — Mon, 20 Nov 2017 15:48:11 GMT

Hi at all

I have this situation

So in the first table i calc the total quantity of purchased materials, first available unit price and then the total amount oof purchased for each product. Then i woul like to obtain a second table with only the total amount by "Bill".

For example in the example i would like obtain 2515 as total amount of "Conto_01" and not 2775.

I used this function

Total Quantity = sum(Quantity)

First Price = Avg({<First_Price = {1}>}Price)

Total Amount = sum(Quantity) * Avg({<First_Price = {1}>}Price)

Is it possible to obtain the target result?

Andrea

Re: Expression Problem

sunny_talwar — Mon, 20 Nov 2017 15:53:11 GMT

Try this

Sum(Aggr(Sum(Quantity) * Avg({<First_Price = {1}>}Price), Bill, Product))

topic Expression Problem in QlikView

Expression Problem

Re: Expression Problem