topic Re: Expression working in QlikView

Expression working

Wed, 25 Nov 2020 16:16:04 GMT

can someone tell how this expression works

Sum(Aggr(Sum(TOTAL <Store, Market> SalesUnits), Store, ProdName, Market))?

sunny_talwar — Tue, 10 Jan 2017 11:53:24 GMT

Did you pick this expression from here?

I did attach a sample. Did you try looking into it?

Tue, 10 Jan 2017 12:07:53 GMT

Yes but could you explain how this expression works ?

Thanks.

sunny_talwar — Tue, 10 Jan 2017 12:13:36 GMT

If you create a straight table using the Aggr() dimensions and this (Sum(TOTAL <Store, Market> SalesUnits)) as expression, you will see this

Basically, it is totaling at Market and Store level. Read about The Aggregation Scope here.

Once you have this, I am just summing these values for Each ProdName. For instance Prod_A appears twice.

1000 + 3400 = 4400

Does this help?

Best,

Sunny

sunny_talwar — Tue, 10 Jan 2017 12:20:29 GMT

I also suggest reading this: