Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Become an analytics expert with Qlik's new 15 week course: Applied Data Analytics using Qlik Sense. READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
shiveshsingh
Master
Master

Error in Creating Calender

A bit silly but can anyone help in getting what's wrong with below script. I only want to use rowno()

let vMIN = num(AddYears(YearStart(Today()),-1));

let vMAX= num(YearStart(Today()));

Calender:load

Date($(vMIN)+RowNo()+1) as Temp_Date

AutoGenerate

$(vMIN)+RowNo()< $(vMAX);

4 Replies
shilpan
Luminary Alumni
Luminary Alumni

Try this:

let vMIN = num(AddYears(YearStart(Today()),-1));


let vMAX= num(YearStart(Today()));


Calender:


load


Date($(vMIN)+RowNo()+1) as Temp_Date


AutoGenerate($(vMAX) - $(vMIN) + 1);

tresesco
MVP
MVP

And the vMin could be simplified using yearstart() parameter perhaps like:

let vMIN = num(YearStart(Today(),-1));

shiveshsingh
Master
Master
Author

Thanks

shiveshsingh
Master
Master
Author

Got it, thanks