Range

[johnan]

hi, is it possible to make 2 colums to one?

I have 2 colums:

1. From
2: To

And the data contains:

(From) = 1
(To) = 4

I want qlikview to show 1 column:

1
2
3
4
Possible?

[prieper]

Not quite clear, what you are up to

FOR i = iFrom TO iTO
MyTable: LOAD $(i) AS MyField AUTOGENERATE 1;
NEXT i

If the variables iFrom and iTo have the values 1 resp 4 the above should generate a table with the 4 values.

HTH
Peter

[johnw]

It could also be done with an intervalmatch as in this thread:

http://community.qlik.com/forums/t/22337.aspx

Not sure which would be more efficient.