topic Expression in dimension in QlikView https://community.qlik.com/t5/QlikView/Expression-in-dimension/m-p/1171044#M462760 <HTML><HEAD></HEAD><BODY><P>I have created a straight table chart with several dimensions and expressions.</P><P>I want to use this valid expression in a dimension but that does not seem to be allowed:</P><P><STRONG>=if(SubStringCount(Concat(DISTINCT field1,'|'),field2)=0,field3) </STRONG></P><P>Is there an easy way to get this done in stead of using this in all expressions?</P></BODY></HTML> Thu, 25 Aug 2016 09:11:31 GMT hansrokers 2016-08-25T09:11:31Z Expression in dimension https://community.qlik.com/t5/QlikView/Expression-in-dimension/m-p/1171044#M462760 <HTML><HEAD></HEAD><BODY><P>I have created a straight table chart with several dimensions and expressions.</P><P>I want to use this valid expression in a dimension but that does not seem to be allowed:</P><P><STRONG>=if(SubStringCount(Concat(DISTINCT field1,'|'),field2)=0,field3) </STRONG></P><P>Is there an easy way to get this done in stead of using this in all expressions?</P></BODY></HTML> Thu, 25 Aug 2016 09:11:31 GMT https://community.qlik.com/t5/QlikView/Expression-in-dimension/m-p/1171044#M462760 hansrokers 2016-08-25T09:11:31Z Re: Expression in dimension https://community.qlik.com/t5/QlikView/Expression-in-dimension/m-p/1171045#M462761 <HTML><HEAD></HEAD><BODY><P>You probably need to use Aggr() to get the correct contexts for the Concat. It is not clear from your explanation how field1, field2 and field3 are associated, so I cannot say exactly how it should look, but it will be something along the lines of:</P><P><EM>Aggr(If(SubStringCount(Concat(DISTINCT field1,'|'), field2) = 0, field3), field3)</EM></P><P></P><P>In general, it would be like </P><P><EM>Aggr(If(SubStringCount(Concat(DISTINCT field1,'|'), field2) = 0, field3), ....)</EM></P><P>where ... is the list of dimensions in the virtual table constructed by Aggr()</P></BODY></HTML> Thu, 25 Aug 2016 09:22:47 GMT https://community.qlik.com/t5/QlikView/Expression-in-dimension/m-p/1171045#M462761 jonathandienst 2016-08-25T09:22:47Z