topic Load & link problem in QlikView

Load & link problem

Tue, 01 Mar 2011 10:00:50 GMT

Hi all

I have the following issue:

We have itemcodes which are linked to fathercodes and itemcodes which are not linked to fathercodes.

Both itemcodes & fathercodes contains sales figures.

I want to load these itemcodes which are linked to fathercodes as the fathercodes but add the sales figure of both the itemcode & fathercode together. On the other hand I want to load those itemcodes which are not linked to any fathercodes as themselves.

Please see attached sheet. This would make it more clear.

Thanks

Load & link problem

Tue, 01 Mar 2011 15:46:46 GMT

What about in your load script something like:

Load

if(isnull(fathercodes),Itemcodes as Itemcodes,

if not isnull(fathercodes), Itemcodes as fathercodes

Load & link problem

suniljain — Tue, 01 Mar 2011 16:13:58 GMT

can you post application with limited data ?.

AW:Load & link problem

Tue, 01 Mar 2011 16:15:21 GMT

Hello Christo,

I would try this, if you want to substitute ItemCode with FatherCode:

LOAD
 If( Len(FatherCode) > 0, FatherCode, ItemCode) AS ItemCode,
 Sales
FROM
[41690.Link Problem.xls]
(biff, embedded labels, table is Sheet1$)
Where RecNo() < 14;

Regards, Roland

AW:Load & link problem

Tue, 01 Mar 2011 16:27:34 GMT

Hello Christo,

sorry this was my first suggestion, had some trouble with my internet connection an hour ago:

Table:
LOAD ItemCode,
 Sales
FROM
[41690.Link Problem.xls]
(biff, embedded labels, table is Sheet1$)
Where RecNo() < 14;

LOAD FatherCode AS ItemCode,
 Sales
FROM
[41690.Link Problem.xls]
(biff, embedded labels, table is Sheet1$)
Where RecNo() < 14
and Len(FatherCode) > 0
;

Regards, Roland

AW:Load & link problem

Fri, 04 Mar 2011 09:11:59 GMT

Hi guys

Thank you for all the responses.

Roland, your sollution worked perfectly.

Regards