Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
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
Author

Anyone can help the above question?