topic Re: Traslate intervals into registers in QlikView

Traslate intervals into registers

Tue, 11 Mar 2014 11:53:48 GMT

Hi, I need to develop a table with intervals into another table with each register of each interval, something like this:

Any tip please?.

Thanks.

MK_QSL — Tue, 11 Mar 2014 12:02:56 GMT

Temp:

Load * Inline

[

From, To, Tag

60, 68, pepe

69, 76, jhon

];

NoConcatenate

Final:

Load

Tag,

From+IterNo()-1 as Account

Resident Temp

While From+IterNo()-1 <= To;

Drop Table Temp;

whiteline — Tue, 11 Mar 2014 18:40:10 GMT

Hi.

You can also use IntervalMatch statement.

regs:

LOAD

RowNo()+59 as account

AUTOGENERATE 16;

intervals:

LOAD * INLINE

[ from, to, tag

60, 68, pepe

69, 76, jhon

];

linktable:

IntervalMatch(account)

LOAD distinct

from,

RESIDENT intervals;