Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
thanks Gysbert
but if I add new columns I have a - there now
Isn't that simply because those Numbers doesn't have an associated Model?
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 ?