Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
cancel
Showing results for 
Search instead for 
Did you mean: 
d_koti24
Creator II
Creator II

let vUpdateDate=peek('Date_updated',-1,'sort_sales');

what is the meaning of the above expr

3 Replies
Not applicable

It finds the last record read in your dataset from column Date_updated in table sort_sales

Note: if it was 0 it was the first record

Not applicable

peek('Date_updated',-1,'sort_sales');


returns the last row from the field Date_updated in the table sort_sales.

your assigning the result to vUpdatedate variable.

tresesco
MVP
MVP

There is table named 'sort_sales' which has a field named 'Date_updated'. If the table has already been loaded into qv, then this expression would store the last field ('Date_updated') value read into the variable called vUpdateDate.

Read Peek(), for details.