topic Set Analysis in QlikView

Set Analysis

zagzebski — Tue, 17 Apr 2012 18:16:27 GMT

}Premium)

Set Analysis

CELAMBARASAN — Tue, 17 Apr 2012 18:21:10 GMT

Hi,

Try with this

Sum({<[Incurred Year]={$(=Max([Incurred Year]))},[Incurred Month Num]={"<=Max([Incurred Month Num])"}, [Incurred Year Month]=>} [NET CHANGE CNT - ADJST])

Celambarasan

Set Analysis

zagzebski — Tue, 17 Apr 2012 21:48:39 GMT

Thanks for the response. Unfortunately it just brough back "0"'s.

Set Analysis

Gabriel — Wed, 18 Apr 2012 15:32:25 GMT

Hi Zag,

Can you expand on your question

Set Analysis

masha-ecraft — Tue, 24 Apr 2012 12:21:52 GMT

I've fixed expression evaluation in the set analysis suggested by Celambarasan, this should work:

Sum({<[Incurred Year]={$(=Max([Incurred Year]))},[Incurred Month Num]={"<=$(=Max([Incurred Month Num]))"}, [Incurred Year Month]=>} [NET CHANGE CNT - ADJST])