topic Set Analysis Problem in QlikView

Set Analysis Problem

Fri, 31 Aug 2012 19:40:38 GMT

I have this expression:

sum( {$<Month = {$(=Only(Month)-1)}>} if( Flag <> 'Fail' , 1, 0) )

But this way doesn't work, the result is always 0...

Someone know what's happen?

Thanks.

sebastiandperei — Fri, 31 Aug 2012 19:52:05 GMT

Hi,

With Only (Month), you need ALWAYS have a Month selected. Try with:

sum( {$<Month = {$(=Max(Month)-1)}>} if( Flag <> 'Fail' , 1, 0) )

But for January Month this wont work, because the expression is not correctly made. Could you send a copy?

(hablás español?)

whiteline — Sat, 01 Sep 2012 14:40:39 GMT

What are your dimensions for this expression ? And what is the Flag ?