topic Re: how to make a sum in QlikView

how to make a sum

Luke_Killer_IT — Fri, 08 Oct 2021 11:31:20 GMT

Hi,

I have a problem with counting totals in a new table. I don't know how to make the new table show the same total as the old table but the problem is that in the new table I have to group by calendar and in the old table I have to group by article

Old table:

Script:if((sum({<Merkmal={"23"}>}Auspr)>=8500 )/16000,'1',sum({<Merkmal={"23"}>}Auspr)/16000)

new table:

Script:sum({<Merkmal={"23"}>}Auspr)/16000

Re: how to make a sum

MayilVahanan — Mon, 11 Oct 2021 04:59:54 GMT

May be, try like below

Sum({<Merkmal={"23"}>}Aggr(sum({<Merkmal={"23"}>}Auspr)/16000, Teile, KW))

Re: how to make a sum

Mario_ES — Mon, 11 Oct 2021 06:37:35 GMT

It may be that there are some Null values in one of the fields of selection.

Re: how to make a sum

Luke_Killer_IT — Tue, 12 Oct 2021 05:03:49 GMT

hi Mayil

its not working 😞

Re: how to make a sum

MayilVahanan — Tue, 12 Oct 2021 06:17:00 GMT

can you share sample app??

Re: how to make a sum

Luke_Killer_IT — Tue, 12 Oct 2021 06:19:26 GMT

Unfortunately, that can be a problem

Re: how to make a sum

Luke_Killer_IT — Tue, 12 Oct 2021 06:23:14 GMT

Maybe the problem is with the 1 in this upper scrypice, notice that if it exceeds the given amount it has to write one

Re: how to make a sum

marcus_sommer — Tue, 12 Oct 2021 07:29:22 GMT

Both expressions aren't identically and therefore it's rather unlikely that they would return the same results. Beside this the expression isn't a simple aggregation else it contains conditions which are related to the dimensionally context in which they are performed.

This means you need to unify both expressions in regard to the mentioned context. If we assume that your first expression/object is correct you need for the second object an expression like this one:

sum(aggr(Expression, Teile, KW))

- Marcus

Re: how to make a sum

Luke_Killer_IT — Tue, 12 Oct 2021 07:32:49 GMT

Thank you