topic How to write script to get values in QlikView https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561826#M1135399 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I need to get the column Type values in straight table as</P><P></P><P><STRONG>If Type not equal to Cheque,DD,CreditCard then Type</STRONG></P><P></P><P></P><P>Could anyone help me how to write statement.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 15 Oct 2013 15:25:29 GMT 2013-10-15T15:25:29Z How to write script to get values https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561826#M1135399 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>I need to get the column Type values in straight table as</P><P></P><P><STRONG>If Type not equal to Cheque,DD,CreditCard then Type</STRONG></P><P></P><P></P><P>Could anyone help me how to write statement.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 15 Oct 2013 15:25:29 GMT https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561826#M1135399 2013-10-15T15:25:29Z Re: How to write script to get values https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561827#M1135400 <HTML><HEAD></HEAD><BODY><P>Try</P><P>If(Not MixMatch(Type, 'Cheque', 'DD', 'CreditCard'), Type)</P></BODY></HTML> Tue, 15 Oct 2013 15:31:58 GMT https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561827#M1135400 CELAMBARASAN 2013-10-15T15:31:58Z Re: How to write script to get values https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561828#M1135401 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this :</P><P>If(Match(Type, 'Cheque', 'DD', 'CreditCard') = 0, Type)</P></BODY></HTML> Tue, 15 Oct 2013 15:46:48 GMT https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561828#M1135401 2013-10-15T15:46:48Z Re: How to write script to get values https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561829#M1135402 <HTML><HEAD></HEAD><BODY><P>Thanks it's working</P></BODY></HTML> Tue, 15 Oct 2013 16:01:05 GMT https://community.qlik.com/t5/QlikView/How-to-write-script-to-get-values/m-p/561829#M1135402 2013-10-15T16:01:05Z