topic autogenerate in QlikView

autogenerate

Sat, 31 Mar 2012 06:07:41 GMT

how autogenerate works in qlikview?

autogenerate

Jason_Michaelides — Sat, 31 Mar 2012 06:59:27 GMT

Start with the F1 help and reference manual - they are pretty good explanations.

autogenerate

adhudson — Sat, 31 Mar 2012 07:19:58 GMT

Hi,

Autogenerate is a function that can be used with Load Statement in the script side.

This function is used to generate specified number of rows using script.

For ex: during the calendar table creation this function is used as below.

LET vDateMin = Num(Peek('Start_Date_AP', 0, 'AP_Link_Table'));

LET vDateMax = Num(Peek('End_Date_AP', -1, 'AP_Link_Table'));

LET vDateToday = Num(Today());

TempCalendar1:

LOAD

$(vDateMin) + RowNo() - 1 AS Date_Key,

Date($(vDateMin) + RowNo() - 1) AS Date

AUTOGENERATE 1

WHILE $(vDateMin)+IterNo()-1<= $(vDateMax);

Master_Calendar:

load Date_Key

,Date

,Date as EMp_date

//,Day(Date) as Day

//,Week(Date) as Week

,WeekName(Date) as WeekName

//,month(Date) as Month

,MonthName(Date) as MonthName

,MonthName(Date) as Period

,Quartername(Date) as QuarterName

,ApplyMap('Quarters_Map',num#(month(Date)))as Quarter

,year(Date) as CalendarYear

,WeekDay(Date) as WeekDay

,text(weekday(Date)) as Week_Day1

Resident TempCalendar1;

DROP Table TempCalendar1;

Let me know if u ve any more questions

Regards

Hudson

Re: autogenerate

Anonymous — Wed, 28 Mar 2018 12:23:43 GMT

How can I start the help with F1 ? thanks..

Re: autogenerate

Anonymous — Wed, 28 Mar 2018 12:30:24 GMT

Trying the script I have the following error:

Field not found - <<=>

TempCalendar1:

LOAD

+ RowNo() - 1 AS Date_Key, Date( + RowNo() - 1) AS Date

AUTOGENERATE 1

WHILE +IterNo()-1<=

...............

thanks for aby assistance

Re: autogenerate

suren946 — Wed, 28 Mar 2018 12:39:40 GMT

AutoGenerate statement takes one parameter that specify the number of rows to generate.

Ex:AutoGenerate(10) - it generates 10 row

Useful when combined with a function such as RecNo() or RowNo()

Re: autogenerate

Anonymous — Wed, 28 Mar 2018 12:43:20 GMT

ok,I knuw, but I can't understand the error in the script

Re: autogenerate

suren946 — Wed, 28 Mar 2018 13:08:53 GMT

Please check if below helps you to understand the functionality of AutoGenerate

Autogenerate Your Data

Re: autogenerate

Anonymous — Wed, 28 Mar 2018 17:16:45 GMT

ok thanks, same useful examples