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

[#1]

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

[malini_qlikview]

try this

=SubStringCount(GetCurrentSelections(),':')

[MarcoWedel · Accepted solution]

Hi,

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

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

hope this helps

regards

Marco

[#4]

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