Writing expression in Set Analysis for Comparative Analysis

Anonymous — Tue, 06 Nov 2012 04:29:17 GMT

Hi,

I have a expression in following way:

=count((if ([%Lead Status Id]='1' and [Closing Probability]<>'100' and [Entry Date]>=vStartDate and [Entry Date]<vEndDate,[#SD Id])))

I was told by my friend that we require set analysis if we want to use Comparative Analysis which is new in Qlikview 11

I want to compare Agent1 with Agent2

Can u help me with the expressions for the same

Thanks a ton

Re: Writing expression in Set Analysis for Comparative Analysis

Anonymous — Mon, 04 Feb 2013 23:45:51 GMT

=count({[Group2]}(if ([%Lead Status Id]='1' and [Closing Probability]<>'100' and [Entry Date]>=vStartDate and [Entry Date]<vEndDate,[#SD Id])))

Question resolved

Just info for other members so that they dont waste time researching