topic Can't get my data right. in QlikView

Can't get my data right.

Thu, 24 Feb 2011 11:01:04 GMT

hi,

i have 2 datatables, one with handled numbers and one with unhandled number. when i load them seperatly i get the right total of numbers but when i load them both the total of handled numbers is still right but the total of unhandled numbers ain't right anymore.

i know that the data is handled if the transmit number has a value, if its just a space its unhandled.

Directory;
LOAD

TRANSMITNR
if (((TRANSMITNR like ' ')),'no','yes') as HANDLED,
ARTNR,
ARTDEC,
EPIKIND,
AMOUNT
FROM
[Data\UNHANDLED\tab201102.xls]
(biff, embedded labels, table is [Sheet 1$]);

Directory;
LOAD
TRANSMITNR,
if (((TRANSMITNR like ' ')),'no','yes') as HANDLED,
ARTNR,
EPIKIND,
VSC_MONTH,
CLASS,
AMOUNT
FROM
[Data\HANDLED\tab200923.xls]
(biff, embedded labels, table is [Sheet 1$]);

how come i only get the right total amount of handled data and not of the unhandled data if i run this script?

please help.

Can't get my data right.

Anonymous — Thu, 24 Feb 2011 11:18:43 GMT

I am not sure but I think Qlikview combines the data when you use the same field names, so it will just add it togehter.

Try to load it like this: (just to see what happens)


QUALIFY *;

Unhandled:
Unqualify TRANSMITNR;
LOAD
TRANSMITNR
if (((TRANSMITNR like ' ')),'no','yes') as HANDLED,
ARTNR,
ARTDEC,
EPIKIND,
AMOUNT
FROM
[Data\UNHANDLED\tab201102.xls]
(biff, embedded labels, table is [Sheet 1$]);

Handled:
Unqualify TRANSMITNR;
LOAD
TRANSMITNR,
if (((TRANSMITNR like ' ')),'no','yes') as HANDLED,
ARTNR,
EPIKIND,
VSC_MONTH,
CLASS,
AMOUNT
FROM
[Data\HANDLED\tab200923.xls]
(biff, embedded labels, table is [Sheet 1$]);
UNQUALIFY*;

Can't get my data right.

Anonymous — Thu, 24 Feb 2011 11:20:06 GMT

PS. Assuming that TRANSMITNR is the field you want to combine the tables

Can't get my data right.

Thu, 24 Feb 2011 11:34:57 GMT

the data has to be added together so i have a listbox with al my data... but then i have a choicebox where i can press yes or no so it would show only handled or unhandled data. so if i press yes it only shows the handled data and its amount, that's correct but when i press no it shows the data but the amount ain't the right amount. When i only run the "unhandled" script without the "handled' script the amount is right.

Can't get my data right.

Thu, 24 Feb 2011 13:23:41 GMT

okey found it 😛 in the other table were other fields so i just had to concatenate them.

load handled
:
:

concatenate load unhandled
:
: