Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Concatenation fails

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?

Tags (1)
4 Replies
biester
Valued Contributor

Concatenation fails

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

Rgds,
Joachim

Not applicable

Concatenation fails

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

biester
Valued Contributor

Concatenation fails

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

Not applicable

Concatenation fails

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

Community Browser