Discussion Board for collaboration related to QlikView App Development.
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
Go to Solution.
use only single quote.
let booking = peek('booking-no ',-1,'booking ');
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
you are done table ascending order before use peek function.
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');
load * resident <table name> order by <field name> asc
here now aplly peek function.
I have created a tmptable for sorting and dropped the table