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: 
Yousef_Amarneh
Partner - Creator III
Partner - Creator III

Generate numbers in range

Hello,

I need to generate numbers between a range in the load script, please see attached an excel sheet that contains 2 sheets, I need to use the data in sheet1 to get the data in End Result sheet (convert the range to actual data in one column)

Thanks.

Yousef Amarneh
1 Solution

Accepted Solutions
maxgro
MVP
MVP

Hi Yousef

try this

Regards

Directory;

Tmp:

LOAD Name,

     From,

     To

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Table:

NoConcatenate

Load

      Name,

      From + IterNo() - 1 as NewField          // Number

      Resident Tmp

      While IterNo() <= To - From + 1 ;

    

    

DROP Table Tmp;    

View solution in original post

4 Replies
maxgro
MVP
MVP

Hi Yousef

try this

Regards

Directory;

Tmp:

LOAD Name,

     From,

     To

FROM

Book1.xlsx

(ooxml, embedded labels, table is Sheet1);

Table:

NoConcatenate

Load

      Name,

      From + IterNo() - 1 as NewField          // Number

      Resident Tmp

      While IterNo() <= To - From + 1 ;

    

    

DROP Table Tmp;    

MayilVahanan

HI

PFA

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Yousef_Amarneh
Partner - Creator III
Partner - Creator III
Author

Thanks

Yousef Amarneh
Not applicable

Hey guys, 

I am given a task to calculate the frequency of calls across a territory. If the rep called a physician regarding the sale of the product 5 times, then frequency is 5 and HCP count is 1....I generated frequencies from 1 to 124 in my pivot table using a calculated dimension which is working fine. But my concern is :

My manager wants frequencies till 19 in order from 1..2..3..4...5..6.....19...

And from the frequency 21-124 as 20+.

I would be grateful if someone helps me with this.....Eager for the reply....