topic Re: floor(Date) issue in QlikView

floor(Date) issue

Fri, 27 Feb 2015 14:18:40 GMT

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

Fri, 27 Feb 2015 14:19:31 GMT

And How initialized variables is :

Let varMaxDate = max(daystart(DateReceived));

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

luciancotea — Fri, 27 Feb 2015 14:20:33 GMT

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.

Fri, 27 Feb 2015 14:22:00 GMT

Let me check untill that

Fri, 27 Feb 2015 14:25:22 GMT

You are true,

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