Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

Create records as a range between two variables

Hello,

I have no idea if this is possible, but i want to achieve this:

excel file shows:

Namelowest_valuehighest_value
A15
A1214
B2022
B2829
C3034

I now i would like qlikview to automatically create this table below (in the script!) so I can left join 'Value' with an exitisting 'Value' of another table so the name is added to that table.

NameValue
A1
A2
A3
A4
A5
A12
A13
A14
B20
B21
B22
B28
B29
C30
C31
C32
C33
C34

You can see that for Name 'A' 5 records have been created with a Value range from 1 to 5 and three records with a range from 12 to 14.

When this table is created I can left join 'Value' with an exitisting 'Value' of another table so the name is added to that table.

Is this possible?

Your help is very much appreciated.

Regards Peter

1 Solution

Accepted Solutions
Highlighted
Not applicable

Re: Create records as a range between two variables

hi,

Check this attach file and let me know.

Regards,

Ashutosh

View solution in original post

3 Replies
Highlighted
MVP
MVP

Re: Create records as a range between two variables

Try using Iterno() in load with a while clause .

Highlighted
Not applicable

Re: Create records as a range between two variables

hi,

Check this attach file and let me know.

Regards,

Ashutosh

View solution in original post

Highlighted
Creator
Creator

Re: Create records as a range between two variables

Yes this works perfect.

I've already implemented this in my project.

Thanks!

Regards,

Peter