topic Re: stuck with where script while loading data. in QlikView https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673649#M244617 <HTML><HEAD></HEAD><BODY><P>Do you mean like below:</P><P></P><P>LOAD</P><P>*</P><P>Resident TableName</P><P>where Match(Code,'AC','CC') and Match(class,'Loss','Tenure');</P></BODY></HTML> Thu, 11 Sep 2014 06:27:30 GMT 2014-09-11T06:27:30Z stuck with where script while loading data. https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673647#M244615 <HTML><HEAD></HEAD><BODY><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Code</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>class</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><P><STRONG>amount</STRONG></P></TH></TR><TR><TD style="padding: 2px;">AC</TD><TD style="padding: 2px;">Loss</TD><TD style="padding: 2px;">12</TD></TR><TR><TD style="padding: 2px;">BC</TD><TD style="padding: 2px;">Gain</TD><TD style="padding: 2px;">25</TD></TR><TR><TD style="padding: 2px;">CC</TD><TD style="padding: 2px;">Tenure</TD><TD style="padding: 2px;">56</TD></TR></TBODY></TABLE><P>how to write script for code,class dimensions for calculating measure Loss Ratio.</P><P>Let say to calculate Loss Ratio the condition is it should take while loading in script.&nbsp; </P><P>Code='AC<SPAN style="line-height: 53.0969924926758px;">','CC' &amp;Class='Loss','Tenure' .how to write code in edit script</SPAN></P></BODY></HTML> Thu, 11 Sep 2014 06:21:01 GMT https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673647#M244615 Anonymous 2014-09-11T06:21:01Z Re: stuck with where script while loading data. https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673648#M244616 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Write</P><P>If(wildmatch(code,'AC','CC') AND wildmatch(Class,'Loss'),Tenure) as NewTenure</P><P></P><P>Regards,</P></BODY></HTML> Thu, 11 Sep 2014 06:26:36 GMT https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673648#M244616 PrashantSangle 2014-09-11T06:26:36Z Re: stuck with where script while loading data. https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673649#M244617 <HTML><HEAD></HEAD><BODY><P>Do you mean like below:</P><P></P><P>LOAD</P><P>*</P><P>Resident TableName</P><P>where Match(Code,'AC','CC') and Match(class,'Loss','Tenure');</P></BODY></HTML> Thu, 11 Sep 2014 06:27:30 GMT https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673649#M244617 2014-09-11T06:27:30Z Re: stuck with where script while loading data. https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673650#M244618 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Whats your expected output? is it 68?</P><P></P><P>Regards,</P><P>Ajay</P></BODY></HTML> Thu, 11 Sep 2014 06:27:58 GMT https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673650#M244618 ajaykumar1 2014-09-11T06:27:58Z Re: stuck with where script while loading data. https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673651#M244619 <HTML><HEAD></HEAD><BODY><P>Thank for your response working on real data if it works I will close discussion</P></BODY></HTML> Thu, 11 Sep 2014 06:35:02 GMT https://community.qlik.com/t5/QlikView/stuck-with-where-script-while-loading-data/m-p/673651#M244619 Anonymous 2014-09-11T06:35:02Z