topic Range in QlikView

Range

johnan — Tue, 10 Nov 2009 01:24:52 GMT

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 — Tue, 10 Nov 2009 04:18:10 GMT

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 — Wed, 11 Nov 2009 06:33:48 GMT

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

Not sure which would be more efficient.