Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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.

View solution in original post

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.