topic Re: Peek Function on Field with spaces or Chars in QlikView

Peek Function on Field with spaces or Chars

rustyfishbones — Tue, 05 May 2015 11:38:24 GMT

Hi All,

I have a SQL SELECT Statement and I want to use peek to get the last record loaded

My field is called booking-no, so I need to use "", but the peek function does not like the double quotes.

How can I get around this for the first parameter in the peek function

Tue, 05 May 2015 11:41:58 GMT

use only single quote.

let booking = peek('booking-no ',-1,'booking ');

rustyfishbones — Tue, 05 May 2015 11:47:04 GMT

Hi radha,

I tried that originally and I got no result so assumed that it was because of the - between booking-no

It seems to be working with just the single quotes but definetly was not earlier today

Thanks

Regards

Alan

Tue, 05 May 2015 11:49:35 GMT

you are done table ascending order before use peek function.

sunny_talwar — Tue, 05 May 2015 11:49:57 GMT

and I would not leave any spaces after booking-no just to make sure I am not leaving any loose ends:

LET booking - peek('booking-no', -1, 'Booking');

Tue, 05 May 2015 11:53:26 GMT

load * resident <table name> order by <field name> asc

here now aplly peek function.

rustyfishbones — Tue, 05 May 2015 11:55:06 GMT

thanks radha,

I have created a tmptable for sorting and dropped the table

Regards

Alan