Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

List out the value give certain range

Hi All,

Anyone can help on this? Refer to tables below.

MeasurementRange1Range2Range3
AAAA000-2006000-700080-90
BBBB

111-300

8000-900060-50
CCCC200-4004000-5000

90-100

I would like to list out all the range in row by row as per below table.

MeasurementRange1Range2Range3
AAAA000600080
AAAA001600181
AAAA002600282
BBBB
CCCC
CCCC

Would like to list out all the range from 000 till 200 for AAAA and others as well. Any idea?

Regards,

OrangezKhoo

1 Reply
Not applicable

Re: List out the value give certain range

Anyone can help the above question?