topic Inteno() function. in QlikView

Inteno() function.

Thu, 11 Feb 2016 14:54:02 GMT

[ExpenseEnd Date] > MonthStart(addmonths(ExpenseStartDate, ExpenseFrequencyNum*(iterno()-1)));

Trying to understand the above script.What exactly it is doing ?

ExpenseEnd Date = 12/31/2020

ExpenseStartDate = 1/1/2016

ExpenseFrequencyNum = 1

Thank you.

Re: Inteno() function.

sunny_talwar — Thu, 11 Feb 2016 14:56:59 GMT

It seems like you are adding the missing Month between 12/31/2020 and 1/1/2016.

So starting with 1/1/2016, every While loop will add a month to it until it reaches 12/31/2020

First While Loop -> 1/1/2016

Second While Loop -> 2/1/2016

Third While Loop -> 3/1/2016

and so on.

Re: Inteno() function.

Peter_Cammaert — Thu, 11 Feb 2016 15:01:31 GMT

Iterno() returns the current cycle count value in a LOAD... WHILE...; statement.

If the expression you posted is part of the WHILE condition, then the LOAD will generate rows for 1/1/2016, 2/1/2016, up to 12/1/2020. With the current lack of context details, that's about as much explanation I can give you.

Best,

Peter

Re: Inteno() function.

hic — Thu, 11 Feb 2016 15:05:11 GMT

An example of how to use While and IterNo() can be found on Creating Reference Dates for Intervals.

HIC