partial sum problem

[#1]

Hello

sorry if Im asking something easy but Im very new to QW

I have this expresion an i cant get partial sum . What am I doing wrong ?

IF(findoc_series='1101'OR(findoc_series= '1106'),1 )

Thanks in advance

[iktrayanov]

It isn't clear what are you trying to do. Is this an expression or is this in your script? What are you trying to sum?

[swuehl]

Ionnis,

please read

http://community.qlik.com/blogs/qlikviewdesignblog/2013/08/06/it-s-all-aggregations

You should use an aggregation function in your expression.

In the context of your partial sums, findoc_series is probably not unambiguous, so the expression can't evaluated to a value.

Are you looking for something like this?

=sum(if( findoc_series = 1101 or findoc_series = 1106, 1))

[#4]

When i use this =sum(if( findoc_series = 1101 or findoc_series = 1106, 1))  i get

but this is not right for the column CUSTOMERS

when i use         if( findoc_series = 1101 or findoc_series = 1106, 1)  i get

this is correct for the number of customers by row but i dont have a Sum at the top

[swuehl]

It seems like you want a sum of rows in a pivot table, so maybe like

=sum( aggr( if( findoc_series = 1101 or findoc_series = 1106, 1), Dim1, Dim2, Dim3, Dim4))

Replace Dim1 ... Dim4 with your chart dimension fields.

[iktrayanov]

Change you total mode from expression default to sum

[iktrayanov]

[#8]

This returns 0 to all fields

[#9]

how can i do this ? the Total Mode is Expression Total by default and i have no choice

[iktrayanov]

Try this =count(if( findoc_series = 1101 or findoc_series = 1106, 1))