topic Re: Matching function ()? in QlikView https://community.qlik.com/t5/QlikView/Matching-function/m-p/585532#M479507 <HTML><HEAD></HEAD><BODY><P>Ben ,</P><P>Go to this link </P><P><A _jive_internal="true" href="https://community.qlik.com/thread/41116">http://community.qlik.com/thread/41116</A></P></BODY></HTML> Thu, 30 Jan 2014 03:55:02 GMT sujeetsingh 2014-01-30T03:55:02Z Matching function ()? https://community.qlik.com/t5/QlikView/Matching-function/m-p/585531#M479506 <HTML><HEAD></HEAD><BODY><P>Hi all ,</P><P></P><P>In this business context, I have two databases call A and B in QV. We handled container boxes so there is always Laden or Empty. However in table A , we call it as Contaienr Class Name and in B, we call Transit_Container_Class</P><P></P><P>I am trying to create a table to find the volme of Laden and Empty with expression that is A and B volume. This can be done by</P><P></P><P>=if(Derived_Container_Class_Name='LADEN' or Transit_Container_Class = 'F','LADEN'</P><P>,if(Derived_Container_Class_Name = 'EMPTY' or Transit_Container_Class='E','EMPTY')</P><P>)</P><P></P><P>Hoever, when comes to market, country where there are more than 200, it will be tedious to 'hardcode' in this way.</P><P>is there any code where I can do matching such like if(Country = Transit.Country, show country)</P><P></P><P>thanks</P></BODY></HTML> Thu, 30 Jan 2014 00:56:20 GMT https://community.qlik.com/t5/QlikView/Matching-function/m-p/585531#M479506 n1ef5ng1 2014-01-30T00:56:20Z Re: Matching function ()? https://community.qlik.com/t5/QlikView/Matching-function/m-p/585532#M479507 <HTML><HEAD></HEAD><BODY><P>Ben ,</P><P>Go to this link </P><P><A _jive_internal="true" href="https://community.qlik.com/thread/41116">http://community.qlik.com/thread/41116</A></P></BODY></HTML> Thu, 30 Jan 2014 03:55:02 GMT https://community.qlik.com/t5/QlikView/Matching-function/m-p/585532#M479507 sujeetsingh 2014-01-30T03:55:02Z