topic Re: Minimum, maximum and average price per unit? in QlikView

Minimum, maximum and average price per unit?

Mon, 15 Jul 2013 14:41:28 GMT

I have attached profit of every shipment.

i want a column to show the minimumm average and maximum sales price per unit of each and every part no.

Can anyone help me with this, please?

Re: Minimum, maximum and average price per unit?

Gysbert_Wassenaar — Mon, 15 Jul 2013 18:34:40 GMT

I'm guessing that you want the max, min and average aggregated over ILENo. That would give expressions like:

max(aggr(sum({<[Entry Type] = {1} >}[Sales Amount (Actual)])/Count({<[Entry Type] = {1} >}Quantity),ILENo))

min(aggr(sum({<[Entry Type] = {1} >}[Sales Amount (Actual)])/Count({<[Entry Type] = {1} >}Quantity),ILENo))

avg(aggr(sum({<[Entry Type] = {1} >}[Sales Amount (Actual)])/Count({<[Entry Type] = {1} >}Quantity),ILENo))

Re: Minimum, maximum and average price per unit?

Tue, 16 Jul 2013 03:05:15 GMT

Dear Gysbert,

i am not getting the correct answer for this.

pls see the atatchment. i have copied your formula, i want the maximum sales price per unit.

for eg, when i select a particular item no. all shipments of that item is displayed. it shows the per unit sales price and cost price for all shipments. i want the maximum and minimum price of that item.

Re: Minimum, maximum and average price per unit?

Gysbert_Wassenaar — Tue, 16 Jul 2013 06:04:22 GMT

Try aggregating over Document No_ instead: max(aggr(sum({<[Entry Type] = {1} >}[Sales Amount (Actual)])/Count({<[Entry Type] = {1} >}Quantity),[Document No_]))