Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

floor(Date) issue

Folks,

I am trying load master calender and facing error while load below code:

LOAD date(  floor($(varMaxDate) ) - recno() + 1) as Date

AUTOGENERATE NoOfDays;

Error in expression:

Floor takes 1-3 parameters

LOAD date(  floor() - recno() + 1) as Date

AUTOGENERATE NoOfDays

1 Solution

Accepted Solutions
luciancotea
Specialist
Specialist

varMaxDate doesn't contain a value.

Your initialization is wrong. Use a temporary table to aggregate, then use PEEK() to extract the value and save it to a variable.

View solution in original post

4 Replies
Not applicable
Author

And How initialized variables is :

Let varMaxDate = max(daystart(DateReceived));

Let varMinDate = min(daystart([Inbox.Received on]));

luciancotea
Specialist
Specialist

varMaxDate doesn't contain a value.

Your initialization is wrong. Use a temporary table to aggregate, then use PEEK() to extract the value and save it to a variable.

Not applicable
Author

Let me check untill that

Not applicable
Author

You are true,

Let varMaxDate = max(daystart(DateReceived)); is not getting any dat into variable.