Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
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