topic Re: To show new order in QlikView

To show new order

tan_chungkam — Wed, 25 Nov 2020 16:16:04 GMT

Hi fellas,

I have 2 excel files which are May and June sales report.

The table in each file basically look like as below shown.

I would like to create a column which shows the order whether it is a new order or existing order.

Thus, i looking for a formula / function - if the order no. appear in last month then it is an existing order. if the order no. do not appear in last month then it is a new order.

Is there any function to do that?

Month	Order no.	Order Type	Delivery week
Jan	1111111	New Order	201803
Jan	2222222	New Order	201805
Jan	3333333	New Order	201804
Jan	4444444	New Order	201811
Feb	2222222	Existing Order	201808
Feb	4444444	Existing Order	201811
Feb	5555555	New Order	201812
Mar	4444444	Existing Order	201815
Mar	5555555	Existing Order	201815
Mar	6666666	New Order	201818

Thanks.

Re: To show new order

Anonymous — Thu, 05 Jul 2018 12:46:50 GMT

hello

maybe something like that

load

if(previous([Order no.])<>[Order no.],'New','existing order') as NE

resident sales_report

ORDER BY [Order no.];

Re: To show new order

olivierrobin — Thu, 05 Jul 2018 12:51:33 GMT

hello

load first month

concatenate 2nd month

add a column

if(exists(Order no),1,0) as flag_exist

Re: To show new order

Anonymous — Thu, 05 Jul 2018 13:05:31 GMT

hello

maybe something like that

load

if(previous([Order no.])<>[Order no.],'New','existing order') as NE

resident sales_report

ORDER BY [Order no.],Month;

Re: To show new order

rajeshqvd — Thu, 05 Jul 2018 13:33:14 GMT

if(exists([Order no.]),'Exit Order','New Order') as [Order Type]

Re: To show new order

tan_chungkam — Fri, 06 Jul 2018 01:31:08 GMT

hi rajeshqvd‌

where should i put the formula?

should i put the expression into the 'add a column by using measure'?

or should i put it into the data load editor?

Really appreciate your help.

Re: To show new order

rajeshqvd — Wed, 11 Jul 2018 10:25:44 GMT

Yes put it into the data load editor