topic Re: Calculate total amount for each product in QlikView

Calculate total amount for each product

Anonymous — Tue, 07 May 2013 14:23:38 GMT

Hello,

Could you help me to add expression, which calculate total sum for each product group by TYPE.

Please find attached the file.

Thanks,

alexandros17 — Tue, 07 May 2013 14:33:12 GMT

first expression:

count

(DISTINCT [product ID])

second expression:

sum(Price)

jagan — Tue, 07 May 2013 14:40:03 GMT

Hi,

Please find attached file for solution.

Sum(aggr(Count([product ID])*Max(Price),TYPE, [product ID]))

Hope it helps you.

Regards,

Jagan.

Anonymous — Tue, 07 May 2013 14:46:48 GMT

hello Jagan,

Why did you use Max(Price)? I removed Max and it works.

Thanks again,