This field is required.
Only these extensions are allowed(.jpg, .JPG, .jpeg, .JPEG, .gif, .GIF, .png, .PNG)
Tags cannot contain the characters ' /, \\, #, ?, or ; >,< '
Only these extensions are allowed(.zip,.ZIP,.pdf,.PDF,.qvf,.QVF,.qvw,.QVW)
Discussion Board for collaboration related to QlikView App Development.
I am trying load master calender and facing error while load below code:
LOAD date( floor($(varMaxDate) ) - recno() + 1) as Date
Error in expression:
Floor takes 1-3 parameters
LOAD date( floor() - recno() + 1) as Date
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
And How initialized variables is :
Let varMaxDate = max(daystart(DateReceived));
Let varMinDate = min(daystart([Inbox.Received on]));
Let me check untill that
You are true,
Let varMaxDate = max(daystart(DateReceived)); is not getting any dat into variable.