topic Re: Doubt with if analysis in QlikView

Doubt with if analysis

Wed, 25 Nov 2020 16:16:04 GMT

Hello everybody

I'm returning to develop after a long time so i have an easy question

I'm doing this

IF( SUM(A) <> 0 , SUM(B))

This works but in the pivot table when i collapse the '<> 0' doesn't work and the sum isn't correct

Thanks, Greetings.

sunny_talwar — Wed, 10 Aug 2016 19:06:27 GMT

The overall Sum is not correct or the line level sum isn't matching? May be you need to add Sum(Aggr()) function in there

Wed, 10 Aug 2016 19:07:36 GMT

Have you tried total mode to be expression total in expressions tab?

Fri, 12 Aug 2016 19:05:45 GMT

The sum is OK. The total isn't working

What do you think i should do?

I tried aggr like with the two dimmensions but i don't see the total. What do you suggest with the aggr?

Fri, 12 Aug 2016 19:06:04 GMT

i can't do that with pivot table.

sunny_talwar — Fri, 12 Aug 2016 19:07:57 GMT

Did you try like this?

Sum(Aggr(If(Sum(A) <> 0 , Sum(B)), Prd_Desc_Group, Prd_Mat_Group_Ext))