topic Re: matching values from different columns in QlikView

matching values from different columns

Thu, 13 Dec 2012 12:31:13 GMT

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

Re: matching values from different columns

Gysbert_Wassenaar — Thu, 13 Dec 2012 12:43:47 GMT

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.

Re: matching values from different columns

Thu, 13 Dec 2012 13:54:44 GMT

thanks Gysbert

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

Re: matching values from different columns

gandalfgray — Thu, 13 Dec 2012 14:01:15 GMT

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

Re: matching values from different columns

Thu, 13 Dec 2012 14:08:49 GMT

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 ?