topic Re: auto generate in QlikView

auto generate

Wed, 16 Apr 2014 17:44:05 GMT

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 — Wed, 16 Apr 2014 17:55:18 GMT

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 — Wed, 16 Apr 2014 17:56:39 GMT

Let vMin = 2011;

Let vMax = 2018;

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

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

its_anandrjs — Wed, 16 Apr 2014 18:04:14 GMT

Oh are you check my solution is it wrong.