topic Re: Error in expression in QlikView https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765671#M272103 <HTML><HEAD></HEAD><BODY><P>Hi Hammad,</P><P></P><P>Could you explain what r u trying to do with the above expression.</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Wed, 03 Dec 2014 08:58:52 GMT sushil353 2014-12-03T08:58:52Z Error in expression https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765670#M272102 <HTML><HEAD></HEAD><BODY><P>=sum(if(Index(GetFieldSelections(Medication_Tree),Concat('Cost.Sub_Cost_Category1 and&nbsp; Cost.Sub_Cost_Category2')&gt;0),1,0))</P></BODY></HTML> Wed, 03 Dec 2014 08:54:31 GMT https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765670#M272102 2014-12-03T08:54:31Z Re: Error in expression https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765671#M272103 <HTML><HEAD></HEAD><BODY><P>Hi Hammad,</P><P></P><P>Could you explain what r u trying to do with the above expression.</P><P></P><P>HTH</P><P>Sushil</P></BODY></HTML> Wed, 03 Dec 2014 08:58:52 GMT https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765671#M272103 sushil353 2014-12-03T08:58:52Z Re: Error in expression https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765672#M272104 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">try this<BR /></SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">sum(if(Index(GetFieldSelections(Medication_Tree),('Cost.Sub_Cost_Category1 &amp; Cost.Sub_Cost_Category2')&gt;0),1,0))</SPAN></P></BODY></HTML> Wed, 03 Dec 2014 09:02:37 GMT https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765672#M272104 SunilChauhan 2014-12-03T09:02:37Z Re: Error in expression https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765673#M272105 <HTML><HEAD></HEAD><BODY><P>A bit of context would be good <IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P></BODY></HTML> Wed, 03 Dec 2014 09:02:46 GMT https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765673#M272105 2014-12-03T09:02:46Z Re: Error in expression https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765674#M272106 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Concat is an aggregation function, not a string concatenation operator. Use &amp; for this. But in your case, if I correctly understand what you are trying to do, I suggest that you use WildMatch:</P><P></P><P>=sum(if(WildMatch(GetFieldSelections(Medication_Tree), '*Cost.Sub_Cost_Category1*', '*Cost.Sub_Cost_Category2*') &gt; 0), 1, 0)</P><P></P><P>(count 1 if one or both of the strings are in the selection(s) for Medication_Tree)</P><P>HTH</P><P>Jonathan</P></BODY></HTML> Wed, 03 Dec 2014 09:10:26 GMT https://community.qlik.com/t5/QlikView/Error-in-expression/m-p/765674#M272106 jonathandienst 2014-12-03T09:10:26Z