topic Re: Resident load,variable in QlikView

Resident load,variable

Fri, 31 Oct 2014 07:58:15 GMT

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,

its_anandrjs — Fri, 31 Oct 2014 08:13:36 GMT

Hi,

Use single quotes for the varaible like

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

Regards

Anand

MK_QSL — Fri, 31 Oct 2014 08:14:29 GMT

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'));