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

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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