Re: Split a range of numbers from two different fi... - Qlik Community

geogou1973 · ‎2021-07-01

Hello,

I have the following table

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

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

Thank you in advance.

kaushiknsolanki · ‎2021-07-01

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

geogou1973 · ‎2021-07-02

Hello Kaushik ,

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

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