Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

help4qv123
Contributor II

Pivot Table expression row count

Hello Experts,

I have some problem in partial count of an expression.

Capture.PNGjavascript:;

Chart1 is the default chart of a pivot table. In the third expression the logic is if the 2nd exp value <>0 then only those values should appear. That's fine. But when i apply partial sum that also applies to the missing value. Instead of 78 i am getting the same 79.

QVW attached. !

1 Solution

Accepted Solutions

Re: Pivot Table expression row count

Try this

=Sum(Aggr(If(Sum(Exp2)<>0,

Sum(FullYear)), Dim1, Dim2))

Capture.PNG

View solution in original post

3 Replies

Re: Pivot Table expression row count

Try this

=Sum(Aggr(If(Sum(Exp2)<>0,

Sum(FullYear)), Dim1, Dim2))

Capture.PNG

View solution in original post

help4qv123
Contributor II

Re: Pivot Table expression row count

Thank You . It worked

Highlighted
help4qv123
Contributor II

Re: Pivot Table expression row count

I have tried the same. but i missed to write sum here (...Sum(Exp2).

Thanks:)