topic Problem with Partial Sum in QlikView

Problem with Partial Sum

Thu, 28 Jul 2011 13:26:00 GMT

i m designing a complex pivote table that has conditions on several row for example filed Account group=Banks if negative it will display zero if positive it will show the number.

the issue is that when i choose partial sum it calculate the banks even if it is negative and has a zero value.

any solution

Problem with Partial Sum

lironbaram — Thu, 28 Jul 2011 13:36:59 GMT

hei

you need to use Aggr function

if you can be more spesific about the expression

i can be more accurate with the answer

Problem with Partial Sum

Thu, 28 Jul 2011 13:49:58 GMT

i have in the expression :

if (sum(amount)<0 and dimention=Banks,0,Sum(Amount))

it is more complex then this but this is the main picture

NB: in sum i used the aggr function but still the totals are wrongs