topic Re: Re: Partial Sums < 0 ? in QlikView

Partial Sums < 0 ?

selcukcadir — Thu, 19 Dec 2013 14:23:39 GMT

Hi all,

How can we solve the problem in the attached document?

Thanks...

Re: Partial Sums < 0 ?

Thu, 19 Dec 2013 14:30:31 GMT

I quite did not understood your question, but I assumed you are trying to filter the records whose sub totals are greater than 0. Please use the below expression in your chart

if(aggr(sum(Sales),LIFNR) < 0, sum(Sales), null())

Re: Partial Sums < 0 ?

selcukcadir — Thu, 19 Dec 2013 14:36:11 GMT

hi,

I've tried. did not work.

Re: Partial Sums < 0 ?

Thu, 19 Dec 2013 14:47:11 GMT

I made the change to the below chart

Re: Partial Sums < 0 ?

Anonymous — Thu, 19 Dec 2013 14:52:51 GMT

try it

sum(aggr(if(sum(TOTAL<LIFNR> Sales) < 0, sum(TOTAL<LIFNR> Sales) ),LIFNR))

Re: Re: Partial Sums < 0 ?

selcukcadir — Thu, 19 Dec 2013 15:39:07 GMT

Thanks Diego..

But,

1 LIFNR - 2 WAERS >>>>>> In the case where. did not work.

Re: Re: Re: Partial Sums < 0 ?

Anonymous — Thu, 19 Dec 2013 15:56:08 GMT

see it

Re: Re: Partial Sums < 0 ?

selcukcadir — Fri, 20 Dec 2013 07:36:53 GMT

Thanks a lot!... Diego