topic Re: Need Help On Aggregation !!!! in QlikView

Need Help On Aggregation !!!!

Mon, 11 May 2015 15:21:58 GMT

Hi,

Need Help On Aggregation i have input like

input:

PO Number	PO Line Item	Amt
100	1	50
100	1	45
100	1	70
100	2	90
100	3	20

output:

PO Number	PO Line Item	Amt	output
100	1	50	47.5
100	1	45	47.5
100	1	70	180
100	2	90	180
100	3	20	180

The Logic is If PO Number and PO Line Item Both are like previous records We have to do the AVG and

if PO Number and PO line item different like previous record we have to do the SUM Of those records as showcase in the Output table

Here am attaching the sample data please help me

In attach file have 2 sheets Sheet1 is input and Sheet2 Is Output

Re: Need Help On Aggregation !!!!

Gysbert_Wassenaar — Wed, 13 May 2015 08:49:12 GMT

I don't understand your logic.

On line 1 I see PO Number 100 and PO Line Item 1. There are no previous rows, i.e. there is no line 0. So what applies here to this line, sum or avg?

On line 3 I see PO Number 100 and PO Line Item 1. Those are the same values as on the previous row. So according to your logic avg should be applied. But your result uses sum instead.

This doesn't make sense.

Re: Need Help On Aggregation !!!!

Wed, 13 May 2015 08:59:32 GMT

Hi ,

Thanks For rly,

If see above output table 3 PO Number and PO Line Item Has been repeated

here the logic is first 2 rows need to be in Average and 3 row which is starting as sequential need to be in sum

please help me in this

Thanks

Re: Need Help On Aggregation !!!!

Gysbert_Wassenaar — Wed, 13 May 2015 14:13:30 GMT

See attached example.