Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
help4qv123
Creator II
Creator 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
sunny_talwar

Try this

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

Sum(FullYear)), Dim1, Dim2))

Capture.PNG

View solution in original post

3 Replies
sunny_talwar

Try this

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

Sum(FullYear)), Dim1, Dim2))

Capture.PNG

help4qv123
Creator II
Creator II
Author

Thank You . It worked

help4qv123
Creator II
Creator II
Author

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

Thanks:)