topic Problem with Peek() in QlikView

Problem with Peek()

rajni_batra — Sun, 30 Dec 2012 12:40:34 GMT

hello frndz,

i have a scenario lyk

here ECoupan is coming 4 times for same id but i want it only once for the first transaction only

i have used expression

if(Peek([Document No_])<>[Document No_],ECouponAmount,'0') as ECouponAmount,

if(previous([Document No_])<>[Document No_],ECouponAmount,'0') as ECouponAmount,

but not giving the desired output, plz help

Sun, 30 Dec 2012 19:40:50 GMT

Hi,

Maybe you should do the Peek with -Booking ID:

e.g :

LOAD

if(Peek([Booking ID])<>[Booking ID],ECouponAmount,'0') as ECouponAmountFinal;

LOAD * INLINE [

Booking ID, Approval Code, Transaction Date, Collection Amount, ECouponAmount

NF2101322199095, , 08/10/2012, 1634, 100

NF2101322199095, , 03/11/2012, 249, 100

NF2101322199095, BYPASS, 04/10/2012, 0, 100

NF2101322199095, 19233, 08/10/2012, 975, 100

];

Anonymous — Sun, 30 Dec 2012 23:05:57 GMT

You may need to relad the table first, with an Order By clause, to make sure it is in the expected order.

Jonathan