Get selected count

Anonymous — Tue, 08 Jul 2014 19:55:03 GMT

Hi friends,

Please help me with idea how to get selected count of my field in inherited state for state2

=if(GetSelectedCount(Campaign2)=0, 'All',

if(GetSelectedCount(Campaign2)<3, Concat({state2} DISTINCT(Campaign2),', '),

'(' &count({state2} DISTINCT Campaign2) &') Campaigns'))

For example working expression:

=num(avg({state2<oDate={">=$(=date(vStart1,'DD/MMM/YYYY'))<=$(=date(vEnd1,'DD/MMM/YYYY'))"}>} TOTAL <oDate> [Purchase Horizon Score]),'#,##0.0')

Thanks,

topic Get selected count in QlikView