Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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?

Community Browser