Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Uploads getting stuck in the virus scanner. We are investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

MaxDate Error

 

I tried loading files using max date.

But error occurs while using where condition.

Table:

Load

ID,

trim(num(date(date#(subfield(Subfield(FileName(),'Incident ',2),'.',1),'DD-MMM-YY'),'DD/MM/YYYY'))) as File

From Excel

 

MaxDate:
Load
max(trim(num(File))) as MDate

Resident Table;

let Vmaxdate=Peek('MDate',0,'MaxDate');

NoConcatenate
Data:
Load *

Resident Log
where num(File)= num($(vMaxFileDate))                     //Unexpected token error occurs while loading using where condition
;

Max Date Error.PNG

4 Replies
Highlighted
Master
Master

the error is in the load?

the variable is Vmaxdate and in where you use vMaxFileDate ?

let Vmaxdate=Peek('MDate',0,'MaxDate');

NoConcatenate
Data:
Load *

Resident Log
where num(File)= num($(vMaxFileDate)) //Unexpected token error occurs while loading using where condition
;

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Highlighted
Creator II
Creator II

Error is in the load. not in the UI.

where num(File)= num($(vMaxFileDate))     //Unexpected Token error

 

Highlighted
Master
Master

if i understood

where num(File)= num($(Vmaxdate) instead of where num(File)= num($(vMaxFileDate))

Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉
Highlighted
Creator II
Creator II

Ah!!! My mistake. It's working now. Many Thanks