Skip to main content
Announcements
Qlik Connect 2025: 3 days of full immersion in data, analytics, and AI. May 13-15 | Orlando, FL: Learn More
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Get selected count

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,

0 Replies