topic Re: Obtain Total in QlikView

Obtain Total

pgalvezt — Tue, 19 Aug 2014 19:42:00 GMT

Hi,

I have to change nums into the fields so I have this:

=Aggr(if(var='1' and codigo='84',7809,if(var='2' and codigo='84',4500000,if (var='2',sum(actual) ,sum(actual1)))),codigo)

So I need to change the cod value (works fine) the problem is that still show the same Total. If a change year for codigo show the total but dissapear the first 2 values.

Re: Obtain Total

Anonymous — Tue, 19 Aug 2014 19:45:25 GMT

could you elaborate may be with screenshots and sample file?

Re: Re: Obtain Total

pgalvezt — Tue, 19 Aug 2014 20:33:30 GMT

I attached sample test with my formula.

Thanks!

Re: Obtain Total

rwunderlich — Tue, 19 Aug 2014 20:39:31 GMT

Wrap the whole thing in a SUM.

-SUM(

Aggr(if(var='1' and codigo='84',7809,if(var='2' and codigo='84',4500000,if (var='2',sum(actual) ,sum(actual1)))),codigo)

)

-Rob

Re: Obtain Total

pgalvezt — Tue, 19 Aug 2014 21:00:41 GMT

Thanks Rob.