topic Load inline with data from other tables in QlikView

Load inline with data from other tables

Mon, 12 Jul 2010 14:44:19 GMT

Hi every body,

I have a small problem with qlikview...

I want to make a LOAD INLINE, but with data that I get from an other table, for example:

Calendrier:

LOAD * INLINE [

LibelleMois, Budget_ER, Realise_ER, Realise_ER_%, Marge, Marge%

janv., Objectif_Mensuel, ER, 100*(Objectiif_Mensuel-ER)/ER, Margin, 100*(ER-Margin)/Margin

];

where Obectif_Mensuel is already in a table named OBJECTIF so I want to get the amount of this data and put it in the LOAD INLINE, same thing for other datas...

Can someone help me please ???

Load inline with data from other tables

suniljain — Mon, 12 Jul 2010 14:48:02 GMT

Load Inline with data from Other table is not possible because of following reason.

Inline is used if data should be typed within the script, and not loaded from a file.

Data entered through an inline clause must be enclosed by quotation marks or with square brackets. The text between these is interpreted in the same way as the content of a file. Hence, where you would insert a new line in a text file, you should also do it in the text of an inline clause, i.e. by pressing the <ENTER> key when typing the script.

Load inline with data from other tables

Mon, 12 Jul 2010 14:55:54 GMT

I see, thanks you anyway

Maybe you can give me an other way to do that then???

I have several tables, each one represents a different month and I want to make a link between them in oder to make a table under Qlikview which gives the datas by month.

Load inline with data from other tables

nathanfurby — Mon, 12 Jul 2010 15:42:51 GMT

It seems to me that you should just do a 'normal' load:

Table2:
LOAD
Column A,
Column B
RESIDENT
Table1;

If you want to 'join' tables together I would think that CONCATENATE is what you want:

Table3:
LOAD
Column A,
Column B
RESIDENT
Table1;

CONCATENATE

LOAD
Column A,
Column B
RESIDENT
Table2;

Load inline with data from other tables

Mon, 12 Jul 2010 16:09:57 GMT

Actually we can say that I want to concatenate but I want to keep the different months

For example:

Sum:
LOAD
Column A,
Column B
RESIDENT
January;

CONCATENATE

LOAD
Column A,
Column B
RESIDENT
February;

But how can I say this amount of column A comes from january and this one from february ???

Load inline with data from other tables

nathanfurby — Mon, 12 Jul 2010 16:38:21 GMT

It's impossible for me to say without understanding what you actually want to do, what the data represents and what format it is in.

If you mean how you can tell which data came from which source (i.e. which month) then you could do the following:

Sum:
LOAD
Column A,
Column B,
'January' AS Month
RESIDENT
January;

CONCATENATE

LOAD
Column A,
Column B,
'February' AS Month
RESIDENT
February;