topic Re: Expression in Pivot Table in QlikView

Expression in Pivot Table

Wed, 08 Aug 2012 08:55:24 GMT

My Pivot table report is somehow looks like

To calculate the "Diff " column value I am using the expression

=if (Count ({$<PeriodName={$(=date(addmonths(PeriodName,-1)))}>} Amount) > 0, 1, 0)

Returning "1"or "0" just to check that expression is working fine, but its not working. Even though Amount is there for April, its returning "0" for May month.

Please do suggest where I am doing wrong in expression.

Thanks.

Re: Expression in Pivot Table

MayilVahanan — Wed, 08 Aug 2012 10:26:21 GMT

use datefield in set analysis..addmonths(periodname,-1) is not datefield...from ur image

Re: Expression in Pivot Table

Thu, 09 Aug 2012 05:52:32 GMT

Hi Mayil,

I have tried that also but no success.

Anyways I got the expected result using the expression

=if( ColumnNo( )<>1,sum(Amount) - before(sum([Amount])) , 0 )