Hi,
I am quite new with QlikView and now I'm trying to solve the following problem (even don't know if this is possible or not). Let me try to explain.
As example, I have two tables with the following structure:
The fist table contains a list of profiles and an interval for each profile. (if the field To is empty the profile has just the value in field from)
| Profile | From | To |
|---|
| A001 | X10 | |
| A002 | X11 | X18 |
| A002 | L12 | |
| A003 | M5 | X15 |
In the second table I have an ordered list of all possible values of fields FROM and TO (domain for that field):
| Header 1 |
|---|
| L12 |
| L15 |
| M1 |
| M3 |
| M5 |
| X10 |
| X11 |
| X15 |
| X17 |
| X18 |
I would like to obtain a table with stored a row for each profile and any possible value, for our example:
| Header 1 | Header 2 |
|---|
| A001 | X10 |
| A002 | X11 |
| A002 | X15 |
| A002 | X17 |
| A002 | X18 |
| A002 | L12 |
| A003 | M5 |
| A003 | X10 |
| A003 | X11 |
| A003 | X15 |
Is that possible??
Thanks in advance,
Mattia.
