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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
NickHoff
Specialist
Specialist

Alternate State on GetSelectedCount

I have a variable defined as:

=GetSelectedCount(MarketName)+GetSelectedCount(Facility)>0

Which works correctly if the state is inherited.  I want to use the states GroupA and GroupB instead of inherited in two different variables.  Although adding the set doesn't seem to work for me:

=GetSelectedCount({GroupA<{}>}MarketName)+GetSelectedCount(GroupA<{}>}Facility)>0


What am I doing incorrectly?

1 Solution

Accepted Solutions
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Starting with QV 11.20 SR8 the getselectedcount function supports an alternate state name as third parameter:

=if(GetSelectedCount(MarketName,0,'GroupA')+GetSelectedCount(Facility,0,'GroupA')>0,1,0)


talk is cheap, supply exceeds demand

View solution in original post

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

Starting with QV 11.20 SR8 the getselectedcount function supports an alternate state name as third parameter:

=if(GetSelectedCount(MarketName,0,'GroupA')+GetSelectedCount(Facility,0,'GroupA')>0,1,0)


talk is cheap, supply exceeds demand