topic Help with using dimension value in set analysis in QlikView https://community.qlik.com/t5/QlikView/Help-with-using-dimension-value-in-set-analysis/m-p/999620#M339868 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a model similar to the one attached. I'm looking for an expression for the IN column to count for the reversed route (OUT is C1 to C2, In would be C2 to C1)</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 09 Sep 2015 07:16:12 GMT 2015-09-09T07:16:12Z Help with using dimension value in set analysis https://community.qlik.com/t5/QlikView/Help-with-using-dimension-value-in-set-analysis/m-p/999620#M339868 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a model similar to the one attached. I'm looking for an expression for the IN column to count for the reversed route (OUT is C1 to C2, In would be C2 to C1)</P><P></P><P>Thanks!</P></BODY></HTML> Wed, 09 Sep 2015 07:16:12 GMT https://community.qlik.com/t5/QlikView/Help-with-using-dimension-value-in-set-analysis/m-p/999620#M339868 2015-09-09T07:16:12Z Re: Help with using dimension value in set analysis https://community.qlik.com/t5/QlikView/Help-with-using-dimension-value-in-set-analysis/m-p/1538076#M439268 Maybe like this:<BR /><BR />OUT:<BR />if(right(Shipper,1)&lt;right(Consignee,1),count(Id))<BR /><BR />IN:<BR />if(right(Shipper,1)&gt;right(Consignee,1),count(Id))<BR /> Thu, 31 Jan 2019 18:47:27 GMT https://community.qlik.com/t5/QlikView/Help-with-using-dimension-value-in-set-analysis/m-p/1538076#M439268 Frank_Hartmann 2019-01-31T18:47:27Z