Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
geogou1973
Creator
Creator

Split a range of numbers from two different fields in continuous numbers

Hello,

I have the following table

ORDERINDEX_FROMINDEX_TO
123451722
567892226

 

how can i split the range of the numbers from each order to continuous numbers like

ORDERINDEX
1234517
1234518
1234519
1234520
1234521
1234522
5678923
5678924
5678925
5678926

 

How can i manage this issue. Can anyone help me ?

Thank you in advance.

Labels (1)
2 Replies
kaushiknsolanki

You should look at the Interval Match function to achieve this.

https://help.qlik.com/en-US/sense/June2019/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptPrefixes...

 

Regards,
Kaushik
If reply is satisfactory, please "Like" the post.
If reply is solution, please mark as "Correct".
geogou1973
Creator
Creator
Author

Hello Kaushik ,

I don't understand how i can take the following result with the expression Interval Match. Can you help me with this ?

ORDERINDEX
1234517
1234518
1234519
1234520
1234521
1234522
5678923
5678924
5678925
5678926