auto generate

[#1]

hi i am new to qlikview

i have min value as 2011 and max as 2018 ,i want to generate all the years between min and max ,

can any body help me.

Thank you

[its_anandrjs]

Write a code like

Let vMin = num(makedate(2011));

Let vMax = num(makedate(2018));

Load Year($(vMin)+RowNo() -1) as Year

AutoGenerate 1

While ($(vMin)+RowNo() -1) < ($(vMax));

[swuehl · Accepted solution]

Let vMin = 2011;

Let vMax = 2018;

LOAD $(vMin)+recno()-1 as Year

autogenerate $(vMax)-$(vMin)+1;

[its_anandrjs]

Oh are you check my solution is it wrong.