topic To show new order in QlikView https://community.qlik.com/t5/QlikView/To-show-new-order/m-p/111983#M766169 <HTML><HEAD></HEAD><BODY><P>I have a table as shown below:</P><P></P><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>Month</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Order No.</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Order Type</TH></TR><TR><TD style="padding: 2px;"><P>Jan</P></TD><TD style="padding: 2px;">11111</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Jan</TD><TD style="padding: 2px;">22222</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Jan</TD><TD style="padding: 2px;">33333</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;">44444</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;">55555</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;"><P>22222</P></TD><TD style="padding: 2px;">Existing Order</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;">33333</TD><TD style="padding: 2px;">Existing Order</TD></TR></TBODY></TABLE><P></P><P></P><P>I would like to using a function/formula to create the order type column.</P><P></P><P>If the order no. appear in previous month, then it is an existing order.</P><P>If the order no. do not appear in previous month, then it is a new order.</P><P></P><P>Is there any way to do it? Thanks for the help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT tan_chungkam 2020-11-25T16:16:04Z To show new order https://community.qlik.com/t5/QlikView/To-show-new-order/m-p/111983#M766169 <HTML><HEAD></HEAD><BODY><P>I have a table as shown below:</P><P></P><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>Month</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Order No.</TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle">Order Type</TH></TR><TR><TD style="padding: 2px;"><P>Jan</P></TD><TD style="padding: 2px;">11111</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Jan</TD><TD style="padding: 2px;">22222</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Jan</TD><TD style="padding: 2px;">33333</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;">44444</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;">55555</TD><TD style="padding: 2px;">New Order</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;"><P>22222</P></TD><TD style="padding: 2px;">Existing Order</TD></TR><TR><TD style="padding: 2px;">Feb</TD><TD style="padding: 2px;">33333</TD><TD style="padding: 2px;">Existing Order</TD></TR></TBODY></TABLE><P></P><P></P><P>I would like to using a function/formula to create the order type column.</P><P></P><P>If the order no. appear in previous month, then it is an existing order.</P><P>If the order no. do not appear in previous month, then it is a new order.</P><P></P><P>Is there any way to do it? Thanks for the help.</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/To-show-new-order/m-p/111983#M766169 tan_chungkam 2020-11-25T16:16:04Z