Transpose interval FROM - TO

Fri, 19 Jul 2013 09:57:38 GMT

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)

In the second table I have an ordered list of all possible values of fields FROM and TO (domain for that field):

I would like to obtain a table with stored a row for each profile and any possible value, for our example:

Is that possible??

Thanks in advance,

Mattia.

topic Transpose interval FROM - TO in QlikView