Concatenate

danosoft — Tue, 19 Oct 2021 08:44:42 GMT

Hi i have this problem with my project, i think it DUPLICATE values, i think the problem is in CONCATENATE, using my QVD files:

IF filetime('.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd') > 0 then
CDG_Gas:
LOAD
NOME,
CONSUMO from '.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd' (qvd);
ELSE
CDG_Gas:
LOAD
NOME,
CONSUMO;
SQL SELECT *
FROM ***:OLD;
STORE CDG_Gas INTO '.\DataStores\TABLE_YEAR_OLD_CDG_GAS.qvd' (qvd);
ENDIF

IF filetime('.\DataStores\V_FATTURATO_CDG_GAS_19.qvd') > 0 then
Concatenate:
CDG_Gas:
LOAD
NOME,
CONSUMO from '.\DataStores\V_FATTURATO_CDG_GAS_19.qvd' (qvd);
ELSE
Concatenate:
CDG_Gas:
LOAD
NOME,
CONSUMO;
SQL SELECT *
FROM ***:19;
STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_GAS_19.qvd' (qvd);
ENDIF

Concatenate:
CDG_Gas:
LOAD
NOME,
CONSUMO;
SQL SELECT *
FROM ***_20;
STORE CDG_Gas INTO '.\DataStores\V_FATTURATO_CDG_GAS_20.qvd' (qvd);
ENDIF

Whei i go in my project if i look values in my Table all is ok, CONSUMO is with right value (25.000).

But when i see in the straight table chart the Sum(Consumo) make me values like are duplicate or similar (51.000)

If i delete all my QVD so it take values from database with SELECT all is ok, but when the second time i reload and it will take the rows from my QVD.... so now i have this problem

topic Concatenate in QlikView

Concatenate