topic Concatenation fails in QlikView

Concatenation fails

Mon, 26 Jan 2026 18:19:17 GMT

Hi all,

i've got a table with a date and a number


ORDERSTAND_OUD:
LOAD
 OpenOrderStand
 ,%Date_Key
FROM [file.qvd] (qvd)
;

I've loaded and calculated some values to a new number for a new date and I named the fields the same.


ORDERSTAND_NIEUW:
LOAD
 SUM(OpenOrderStand_TEMP) + SUM(OrderIntake) - SUM(OrderOutgoing) - SUM(OrderCancel) AS 'OpenOrderStand'
 ,'$(vDatum)' AS %Date_Key
RESIDENT ORDERSTAND_TEMP;

but the tables wont merge. Even if I use CONCATENATE LOAD afterwards it doesn't put the new value in the existing table.

Can somebody help me?

Concatenation fails

biester — Tue, 20 Oct 2009 15:07:44 GMT

Just a guess: the SUM() function in connection with the %Date_key but without any group by clause seems strange to me ...

Rgds,
Joachim

Concatenation fails

Tue, 20 Oct 2009 15:21:28 GMT

The SUM() function works fine. if i create a table with OrderStand_Nieuw as label, it shows the new table correcly.

So, i don't know what's wrong with this

Rgds,

Rey-man

Concatenation fails

biester — Tue, 20 Oct 2009 17:43:53 GMT

Very strange that it works as usually aggregate functions in the script (and generally also in SQL) don't work without a group by clause if used together with not aggregated fields. Actually, if I try similar I get an error (if ErrorMode is not set to 0).

Rgds,
Joachim

Concatenation fails

Tue, 20 Oct 2009 18:15:36 GMT

I too wonder, how it works!. The QV tabel name change (or its case) doesnot matter anyway. I can't visualize such a table structure design.

--Arun