topic Re: Error in Creating Calender in QlikView

Error in Creating Calender

shiveshsingh — Wed, 25 Nov 2020 16:16:04 GMT

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);

shilpan — Sat, 10 Mar 2018 05:17:32 GMT

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);

tresB — Sat, 10 Mar 2018 05:29:53 GMT

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

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

shiveshsingh — Sat, 10 Mar 2018 06:28:37 GMT

Thanks

shiveshsingh — Sat, 10 Mar 2018 06:29:22 GMT

Got it, thanks