topic Re: Sum() operation is returning total sum by default in QlikView

Sum() operation is returning total sum by default

markgraham123 — Tue, 28 Jul 2015 15:07:55 GMT

Hi Everyone,

I'm working on an application, where when i select SKU#, it should show the Warehouse in the chart table and individual sum.

In the end, i have to see the total.

But the total sum is getting populated in all the Sum() fields rather than its own individual sum() values.

PLease look into this.

Re: Sum() operation is returning total sum by default

sorrakis01 — Tue, 28 Jul 2015 15:11:49 GMT

Hi,

In expression write Sum(Aggr(Sum([Qty on Hand]),[ID Warehouse]))

Regards,

Re: Sum() operation is returning total sum by default

markgraham123 — Tue, 28 Jul 2015 15:14:32 GMT

HI,

The expr. is returning zero values.

Re: Sum() operation is returning total sum by default

sorrakis01 — Tue, 28 Jul 2015 15:17:09 GMT

Hi,

See the example.

Regards

Re: Sum() operation is returning total sum by default

markgraham123 — Tue, 28 Jul 2015 15:31:08 GMT

HI,

Please find the app. with updated data..

its not working in the below app.

sorry for inconvenience.

Re: Sum() operation is returning total sum by default

sorrakis01 — Tue, 28 Jul 2015 15:39:45 GMT

Hi Mark,

For understand your problem... your problem exactly is on Total of Simple Chart? now its correctly. In your first example only sums distinct values. And now sum all values.

Maybe the problem it's on your values because you have a Qty 44 on a null dimension.

For understand, where is your problem exactly?

if you prefer you can upload Book1.xls

Thanks

Re: Sum() operation is returning total sum by default

markgraham123 — Tue, 28 Jul 2015 15:43:31 GMT

I want to sum only distinct values but not total values....

Re: Sum() operation is returning total sum by default

sorrakis01 — Tue, 28 Jul 2015 15:47:12 GMT

Hi,

ok and this?

Sum(DISTINCT Aggr(Sum([Qty on Hand]),[ID Warehouse]))

Re: Sum() operation is returning total sum by default

markgraham123 — Tue, 28 Jul 2015 15:51:24 GMT

Hi,

it still shows the total .

Re: Sum() operation is returning total sum by default

awhitfield — Tue, 28 Jul 2015 16:01:28 GMT

Hi Mark,

Should the dimension be Skort_Warehouse and expression just sum(qty on hand)

HTH - Andy