topic Re: Create records as a range between two variables in QlikView

Create records as a range between two variables

pepe2209 — Thu, 21 Nov 2013 13:18:38 GMT

Hello,

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

excel file shows:

Name	lowest_value	highest_value
A	1	5
A	12	14
B	20	22
B	28	29
C	30	34

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.

Name	Value
A	1
A	2
A	3
A	4
A	5
A	12
A	13
A	14
B	20
B	21
B	22
B	28
B	29
C	30
C	31
C	32
C	33
C	34

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

Re: Create records as a range between two variables

tresB — Thu, 21 Nov 2013 13:28:45 GMT

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

Re: Create records as a range between two variables

Thu, 21 Nov 2013 13:49:08 GMT

hi,

Check this attach file and let me know.

Regards,

Ashutosh

Re: Create records as a range between two variables

pepe2209 — Thu, 21 Nov 2013 15:20:50 GMT

Yes this works perfect.

I've already implemented this in my project.

Thanks!

Regards,

Peter