Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
See why IDC MarketScape names Qlik a 2025 Leader! Read more
cancel
Showing results for 
Search instead for 
Did you mean: 
absekrafi
Creator III
Creator III

Adding two Table columns

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);

12 Replies
absekrafi
Creator III
Creator III
Author

The 2 fields are added but there's '-' signe added.

absekrafi
Creator III
Creator III
Author

Perfect it works very much Gerold.

absekrafi
Creator III
Creator III
Author

Thank you very much Gerold. Your solution works.

Also I find on internet NumSum( QUANTITE, QTERED) AS QUANTRED