Skip to main content
Announcements
NEW: Seamless Public Data Sharing with Qlik's New Anonymous Access Capability: TELL ME MORE!
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Resident load,variable

hi

in this document i loaded Sales table  data from excel.

after that using resident load for OrderDate Ascending

but its not worked. AND Also declared a variable for  its not worked .

Kindly find attached file

Regards,

k

2 Replies
its_anandrjs

Hi,

Use single quotes for the varaible like

Let varMinDate =Num(Peek( 'OrderDate',-1,'t1' ));

Regards

Anand

MK_QSL
MVP
MVP

Sample... Work Accordingly

t1:

Load * Inline

[

  OrderDate

  10-10-2014

  15-01-2014

  05-04-2014

];

Temp:

Load Date(Max(OrderDate)) as MaxDate Resident t1;

Let vMaxDate = NUM(PEEK('MaxDate',0,'Temp'));