Writing expression in Set Analysis for Comparative Analysis

[Anonymous]

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

[Anonymous · Accepted solution]

=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