matching values from different columns

[#1]

Hi there,

I want to make a chart with the average wastage per model, but the problem is, that the columns come from different tables, so that I have no values

I have:

Table 1

Number          liter          kilometer

12345              50               5

58963            1945             8

Table 2

Number          Model

12345             250c

58963             320i

but if I make one chart I have no values in Model like in the picture

Is it possible to match the model with the number somehow, so that there is no "-" anymore?

Tanks for help

[Gysbert_Wassenaar]

Try using Table 2 as a mapping table and use the applymap function:

Map1:

mapping load * [

Number, Model

12345, 250c

58963, 320i

];

Table 1:

load *,

applymap('Map1',Number) as Model

inline [

Number, liter,kilometer

12345, 50,5

58963, 1945,8

];

Though if in both tables you have a field named Number (exactly the same name in both tables) then qlikview should associate the two tables on this field and the model should be connected already if the numbers match in both tables.

[#3]

thanks Gysbert

but if I add new columns I have a - there now

[gandalfgray]

Isn't that simply because those Numbers doesn't have an associated Model?

[#5]

fi I make a table witch the "original" Model I have an ID

so I have to connect the other columns too with extra mapping tables ?