topic Re: My multiple expression doesn't quite work. in QlikView

My multiple expression doesn't quite work.

Tue, 01 Mar 2016 08:42:23 GMT

Hey, my current expression looks like this:

Sum(Aggr(IF(Sum({<[Kontonummer]>} [Bokfört belopp]) < 0,Sum([Bokfört belopp]) * Sum([Andel av kapital])), [ID-nummer], [Kontonummer]))

And it's primary job is to multiple [bokfört belopp] with [Andel av kapital] and to sum a total of the outcome at the top.

My problem is now that the multiple function doesn't quite work, as you can see here...

Would really appreciate if someone could help me with this issue.

Kind Regards

D.Z

Tue, 01 Mar 2016 08:46:13 GMT

The multiple function works on the "regular" values but not on the total as it seems...

jonas_rezende — Tue, 01 Mar 2016 13:59:04 GMT

Hi, Daniel Zlokapa.

Ensure that all dimensions are [ID-nummer], [Kontonummer]. Otherwise, you have to include in AGGR() function.

Hope this helps!