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
