topic Re: Expression issue in aggregation in QlikView

Expression issue in aggregation

ravindraa — Sat, 16 Nov 2024 19:34:51 GMT

Hi Exports,

I have small issue on Multiplication .i have two tables like sales_file and price_file like below.

Country SAPcode year Month sales Country SAPcode year Month Price

AE 12345 2019 1 10 AE 12345 2019 1 2

AE 23456 2019 2 20 AE 23456 2019 2 3

Normal Process:-Normally if we load the data and create the expression like sum(sales)* sum(price) result is = 30*5 =150

Required Process:-but my requirement is in 2019 Jan month sales is 10 and same year same month price is 2 then multiply like 10*2 =20

same way second month also in 2019 Feb month sales is 20 and same year same month price is 3 then multiply like 20*3=60.

Normal expression is giving like below result

Country Value(sum(sales) * Sum(Price)) Country Value

AE 150 AE 80 (Expected Result)

kindly give me any suggestion how to achieve .

I have attached sample application please find the same.

Thank you very much in advance........

Re: Expression issue in aggregation

ravindraa — Wed, 27 Nov 2019 02:11:51 GMT

Hi Experts,

kindly give any one of the suggestion last one month on wards i am struggling the same issue .

Please help me .

Thanks in advance......

Re: Expression issue in aggregation

ravindraa — Wed, 27 Nov 2019 16:14:35 GMT

Hi Experts,

kindly give any one of the suggestion last one month on wards i am struggling the same issue .

Please help me .

Thanks in advance......

Re: Expression issue in aggregation

patilamay — Wed, 27 Nov 2019 21:21:57 GMT

I think you need to do this

Sum( sales * price)

HTH

Thanks,

Re: Expression issue in aggregation

qliksus — Thu, 28 Nov 2019 11:24:53 GMT

Since you are just taking the country as a dimension you doing

sum(amount)* sum( price) will be 30*5 = 150

sum(amount * price) will be ( 10*2 + 20*3) = 80

hence try sum(amount * price) if you are taking just one dimension which is not giving the granular details of each row

Re: Expression issue in aggregation

Brett_Bleess — Mon, 09 Dec 2019 22:45:04 GMT

Did either of the posts help you resolve your question? If so, be sure to return to the thread and use the Accept as Solution button on the post(s) that helped. This will give credit to the poster and let other Community Members know what worked. If you still require further assistance, leave an update.

Regards,
Brett