topic Generate a sequence in rows in QlikView

Generate a sequence in rows

jsanchezh — Mon, 26 Jan 2026 18:19:17 GMT

Hello everyone,

I'm facing a trouble trying to generate new rows for a content between two values. I have the following simple example:

VALUE1	VALUE2	NUMBEROFVALUES	PREFIX
ES001	ES004	4	ES
CS002	CS003	2	CS

And I would like to obtain the following result

VALUE1	VALUE2	NUMBEROFVALUES	RESULT
ES001	ES004	4	ES001
ES001	ES004	4	ES002
ES001	ES004	4	ES003
ES001	ES004	4	ES004
CS002	CS003	2	CS002
CS002	CS003	2	CS003

Does anybody know how can I get this?

Thank you very much

Kind regards

m_woolf — Mon, 13 Mar 2017 18:11:41 GMT

sunny_talwar — Mon, 13 Mar 2017 18:14:20 GMT

May be this

Table:

LOAD VALUE1,

VALUE2,

NUMBEROFVALUES,

PREFIX & Num(Start + IterNo()-1, '000') as RESULT

While Start + IterNo()-1 <= End;

LOAD *,

KeepChar(VALUE1, '0123456789') * 1 as Start,

KeepChar(VALUE2, '0123456789') * 1 as End;

LOAD * INLINE [

VALUE1, VALUE2, NUMBEROFVALUES, PREFIX

ES001, ES004, 4, ES

CS002, CS003, 2, CS

];