Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Qlikview Experts,
I am new to Qlikview and I want to add to columns of a Table. The Table is a result of a concatenation of 2 Tables. Please find attached the Table (result of concatenation).
This my script code but it didn't work (the decimal separator is ',' and the thousands separator is either space or null):
Directory;
LOAD CODUSN,
CODEART,
TRANSACTION_DATE,
CODESART,
TYPEART,
CODUNT,
QUANTITE,
NATIO,
CODUSNSRC_DST,
QTERED,
Num( QUANTITE, '###0,###', ',' , ' ' ) + Num(QTERED, '###0,###', ',' , ' ') AS QUANTRED
FROM
[..\..\..\personnel\Qlickview\QVD\TRANSFERT.qvd]
(qvd);
The 2 fields are added but there's '-' signe added.
Perfect it works very much Gerold.
Thank you very much Gerold. Your solution works.
Also I find on internet NumSum( QUANTITE, QTERED) AS QUANTRED