Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

Repeating number of Rows

Hi Guys

I have a table as Follows:

DimensionCodeToFrom
1A13
1B68

and i want the output as

DimensionCodeToFromRange
1A131
1A132
1A133
1B686
1B687
1B688
1 Solution

Accepted Solutions

Re: Repeating number of Rows

Something like this:

Result:

load DimensionCode, To, From, To + iterno() -1 as Range

from ...somewhere...

while To + iterno() -1 <= From;


talk is cheap, supply exceeds demand
1 Reply

Re: Repeating number of Rows

Something like this:

Result:

load DimensionCode, To, From, To + iterno() -1 as Range

from ...somewhere...

while To + iterno() -1 <= From;


talk is cheap, supply exceeds demand
Community Browser