Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Customers, Partners & Luminaries only: You're invited to a Data Analytics Roadmap session. Read More
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
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