need to fix calculated value when table is aggregated

patrou38 — Thu, 11 Oct 2018 07:29:29 GMT

Hello,

I need your help, because I'm totaly lost in front my issue.

I tried to replicate my problem in a simple attached example .

I have a table with 1 week, 7days. 1 Quantity (Qty), 1 coefficient (Coef) and 1 column in wicth I do the Quantity * Coefficient.

it's ok with this, but My problem is that I've to a visibility by Week (instead detailed by days).

When I removed the column 'Day' (either by removing the dimension or by collapsing the column in the pivot table), I obtained a new amount in the calculated column (last one) correspont to the sum of the column Qty * sum of the column Coef.

maybe this is a correct behavior of the tool, but this is not what I would like have. what I would like to obtain in this column is the sum of each day (corresponig to 9369 instead 104827.

I hope that it's enough clear for you.

thank you in advance for your help.

Patrick

Re: need to fix calculated value when table is aggregated

andrey_krylov — Thu, 11 Oct 2018 07:48:16 GMT

Hi, Patrick

=Sum(Aggr(sum(QTY)*sum(Coef), Week, Day))

Re: need to fix calculated value when table is aggregated

patrou38 — Thu, 11 Oct 2018 07:59:23 GMT

Thank you Andrey it seems works properly.

Regards,

Patrick

topic Re: need to fix calculated value when table is aggregated in QlikView

need to fix calculated value when table is aggregated

Re: need to fix calculated value when table is aggregated

Re: need to fix calculated value when table is aggregated