Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to set a condition based on selections in all fields?

Dear Qlik Community,

I have a metric which is calculated from a data island, making any field selection to dissappear said formula. Is there any way I can use the "getselectedcount" formula to be applied to all fields loaded? Or, alternatively, is there any other formula I can use for getting how many fields are being selected? Thanks!

Best regards,

Sergio

1 Solution

Accepted Solutions
MarcoWedel

Hi,

to avoid conflicts with field values including ':' you could change this solution like:

SubStringCount(GetCurrentSelections( '',':','',0),':')

QlikCommunity_Thread_185434_Pic1.JPG

hope this helps

regards

Marco

View solution in original post

3 Replies
malini_qlikview
Creator II
Creator II

try this

=SubStringCount(GetCurrentSelections(),':')

MarcoWedel

Hi,

to avoid conflicts with field values including ':' you could change this solution like:

SubStringCount(GetCurrentSelections( '',':','',0),':')

QlikCommunity_Thread_185434_Pic1.JPG

hope this helps

regards

Marco

Not applicable
Author

Hello Marco,

Thanks a lot for your help!, it totally solves my question. I got another doubt though, if I'd like to count all fields selected but field "X", is there a way to do so? Thanks again!

Best regards,

Sergio