topic Re: Pivot Table expression row count in QlikView

Pivot Table expression row count

help4qv123 — Mon, 23 Apr 2018 15:09:51 GMT

Hello Experts,

I have some problem in partial count of an expression.

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. !

Re: Pivot Table expression row count

sunny_talwar — Mon, 23 Apr 2018 15:19:50 GMT

Try this

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

Sum(FullYear)), Dim1, Dim2))

Re: Pivot Table expression row count

help4qv123 — Tue, 24 Apr 2018 06:43:28 GMT

Thank You . It worked

Re: Pivot Table expression row count

help4qv123 — Tue, 24 Apr 2018 06:48:35 GMT

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

Thanks:)