This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
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.
// DEMO LOADORDER: 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
ORDER:LOAD * Inline [Customer|Order101|2013101|2011102|2009103|2015101|2017103|2018] (delimiter is '|');FIRST_ORDER:LOAD Customer,
Min(Order) As FirstOrderResident ORDER
Group By Customer;