Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
shamad
Contributor II
Contributor II

how to select the last 3 recent orders (Order Date desc) by customer

Hi,

how to select the last 3 recent orders (Order Date desc) by Customer. (create QVD)

The result must be

 

A                           100                       20150220

A                           50                         20150110

A                           20                         20150103

B                           80                         20150215

B                           70                         20150208

B                           30                         20150105

From Table

Customer            N° Order              Date Order

 

A                           50                         20150110

B                           30                         20150105

 

A                           20                         20150103

 

B                           25                         20150104

 

A                           10                         20141225

 

A                           100                       20150220

 

B                           80                         20150215

 

B                           70                         20150208

 

                                                                 

Thanks,

 

 

1 Solution

Accepted Solutions
MK_QSL
MVP
MVP

Test:

Load

  Customer,

  Order,

  Date(Date#([Date Order],'YYYYMMDD')) as [Date Order]

Inline

[

  Customer, Order, Date Order

  A, 50, 20150110

  B, 30,     20150105

  A,          20,     20150103

  B,          25,     20150104

  A,          10,     20141225

  A,          100,    20150220

  B,          80,     20150215

  B,          70,     20150208

];

NoConcatenate

Temp:

Load

  Customer, Order, [Date Order], AutoNumber(Customer & [Date Order], Customer) as Number

Resident Test

Order By Customer, [Date Order] desc;

Drop Table Test;

NoConcatenate

Load * Resident Temp Where Number <=3;

Drop Table Temp;

View solution in original post

2 Replies
alexandros17
Partner - Champion III
Partner - Champion III

This is an example

MK_QSL
MVP
MVP

Test:

Load

  Customer,

  Order,

  Date(Date#([Date Order],'YYYYMMDD')) as [Date Order]

Inline

[

  Customer, Order, Date Order

  A, 50, 20150110

  B, 30,     20150105

  A,          20,     20150103

  B,          25,     20150104

  A,          10,     20141225

  A,          100,    20150220

  B,          80,     20150215

  B,          70,     20150208

];

NoConcatenate

Temp:

Load

  Customer, Order, [Date Order], AutoNumber(Customer & [Date Order], Customer) as Number

Resident Test

Order By Customer, [Date Order] desc;

Drop Table Test;

NoConcatenate

Load * Resident Temp Where Number <=3;

Drop Table Temp;