Peek Question

Anonymous — Thu, 04 Oct 2018 11:56:52 GMT

Hi folks,

i'm having issues with the below. Can you give me the right hint please. I would like to get what is listed as a WISHED RESULT Table. But the script FIRST_ORDER doesn't seem to work.

Thank you,

// DEMO LOAD
ORDER:
Load * Inline [
Customer|Order
101|2013
101|2011
102|2009
103|2015
101|2017
103|2018
] (delimiter is '|');

// THIS DOES NOT WORK NOW
FIRST_ORDER:
Load Customer, Peek(Order,0) As FirstOrder
Resident ORDER;

// WISHED RESULT:
//
// Customer, FirstOrder
// 101, 2011
// 102, 2009
// 103, 2015

Re: Peek Question

sunny_talwar — Thu, 04 Oct 2018 18:58:42 GMT

Try this

ORDER:
LOAD * Inline [
Customer|Order
101|2013
101|2011
102|2009
103|2015
101|2017
103|2018
] (delimiter is '|');

FIRST_ORDER:
LOAD Customer,

Min(Order) As FirstOrder
Resident ORDER

Group By Customer;

topic Re: Peek Question in QlikView

Peek Question

Re: Peek Question