topic Re: How to set a condition based on selections in all fields? in QlikView https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995890#M967366 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>to avoid conflicts with field values including ':' you could change this solution like:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14440874746005019 jive_text_macro" jivemacro_uid="_14440874746005019"> <P>SubStringCount(GetCurrentSelections( '',':','',0),':')</P> </PRE><P></P><P><IMG alt="QlikCommunity_Thread_185434_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101029_QlikCommunity_Thread_185434_Pic1.JPG" style="height: 180px; width: 620px;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 05 Oct 2015 23:25:31 GMT MarcoWedel 2015-10-05T23:25:31Z How to set a condition based on selections in all fields? https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995888#M967363 <HTML><HEAD></HEAD><BODY><P>Dear Qlik Community,</P><P></P><P>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!</P><P></P><P>Best regards,</P><P></P><P>Sergio</P></BODY></HTML> Mon, 05 Oct 2015 11:20:04 GMT https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995888#M967363 2015-10-05T11:20:04Z Re: How to set a condition based on selections in all fields? https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995889#M967364 <HTML><HEAD></HEAD><BODY><P>try this </P><P>=SubStringCount(GetCurrentSelections(),':')</P></BODY></HTML> Mon, 05 Oct 2015 16:32:15 GMT https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995889#M967364 malini_qlikview 2015-10-05T16:32:15Z Re: How to set a condition based on selections in all fields? https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995890#M967366 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>to avoid conflicts with field values including ':' you could change this solution like:</P><P></P><PRE __default_attr="plain" __jive_macro_name="code" class="jive_macro_code _jivemacro_uid_14440874746005019 jive_text_macro" jivemacro_uid="_14440874746005019"> <P>SubStringCount(GetCurrentSelections( '',':','',0),':')</P> </PRE><P></P><P><IMG alt="QlikCommunity_Thread_185434_Pic1.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/101029_QlikCommunity_Thread_185434_Pic1.JPG" style="height: 180px; width: 620px;" /></P><P></P><P>hope this helps</P><P></P><P>regards</P><P></P><P>Marco</P></BODY></HTML> Mon, 05 Oct 2015 23:25:31 GMT https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995890#M967366 MarcoWedel 2015-10-05T23:25:31Z Re: How to set a condition based on selections in all fields? https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995891#M967369 <HTML><HEAD></HEAD><BODY><P>Hello Marco,</P><P></P><P>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!</P><P></P><P>Best regards,</P><P></P><P>Sergio</P></BODY></HTML> Tue, 06 Oct 2015 07:26:04 GMT https://community.qlik.com/t5/QlikView/How-to-set-a-condition-based-on-selections-in-all-fields/m-p/995891#M967369 2015-10-06T07:26:04Z