# QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

cancel
Showing results for
Did you mean:
Creator

## To show new order

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.

1 Solution

Accepted Solutions
Contributor

hello

maybe something like that

*,

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

resident sales_report

ORDER BY [Order no.];

6 Replies
Contributor

hello

maybe something like that

*,

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

resident sales_report

ORDER BY [Order no.];

Specialist III

hello

concatenate 2nd month

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

Contributor

hello

maybe something like that

*,

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

resident sales_report

ORDER BY [Order no.],Month;

Creator II

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

Creator
Author

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?