topic Re: Adding two Table columns in QlikView

Adding two Table columns

absekrafi — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: Adding two Table columns

Anonymous — Wed, 04 Apr 2018 09:15:43 GMT

Hi ,

Writethe conddition is like below.

Num( QUANTITE, '###0,###', ',' , ' ' ) &'-'& Num(QTERED, '###0,###', ',' , ' ') AS QUANTRED

Re: Adding two Table columns

olivierrobin — Wed, 04 Apr 2018 09:51:00 GMT

hello

if you want to add the 2 columns

why don't you use

Num( QUANTITE+QTERED, '###0,###', ',' , ' ') AS QUANTRED

Re: Adding two Table columns

gerry_hdm — Wed, 04 Apr 2018 09:59:00 GMT

you used

RANGESUM()

Re: Adding two Table columns

gerry_hdm — Wed, 04 Apr 2018 10:01:21 GMT

Rangesum(num(QUANTITE) ,num(QTERED) ) AS QUANTRED

so is correktly

this sum all numfielsd

Re: Adding two Table columns

Anonymous — Wed, 04 Apr 2018 10:11:16 GMT

Use & operator to concatenate like below.

Column1 & ' ' & Column2 as Column 3

Re: Adding two Table columns

ramasaisaksoft — Wed, 04 Apr 2018 11:01:53 GMT

Hi Abdallah,

you can achieve this like below

Way 1:-

T1;

LOAD CODUSN,

CODEART,

TRANSACTION_DATE,

CODESART,

TYPEART,

CODUNT,

QUANTITE,

NATIO,

CODUSNSRC_DST,

QTERED,

QUANTITE,

QTERED

FROM

[..\..\..\personnel\Qlickview\QVD\TRANSFERT.qvd]

(qvd);

Load *,

Num( QUANTITE, '###0,###', ',' , ' ' ) + Num(QTERED, '###0,###', ',' , ' ') AS QUANTRED

Resident T1;

Drop Table T1;

Way 2:-

Example i am giving here

LOAD

uniqueid,

residentialunitprice,

maintenancefundprice,

totalcustomizationcharges,

totalservicetax,

totalvat,

wc,

Rangesum(residentialunitprice, maintenancefundprice, totalcustomizationcharges, totalservicetax, totalvat, wc) as S_TotalCharges,

FROM

[tesaleorde.qvd]

(qvd);

In RangeSum() you have give comma not + symbol.

Re: Adding two Table columns

vishalarote — Wed, 04 Apr 2018 12:33:38 GMT

Do one condition

if(QTERED=null(), QUANTITE,

if(QUANTITE=null(),QTERED

if(QTERED=null() and QUANTITE=null(),null(),QUANTITE+QTERED)))as QUANTRED

I hope it will works.

Re: Adding two Table columns

Nagaraju_KCS — Wed, 04 Apr 2018 13:02:19 GMT

HI,

PFA,

Re: Adding two Table columns

vishalarote — Thu, 05 Apr 2018 06:24:30 GMT

try this it will work

demo e.g.

load *,

If(len(trim(v1))= 0,v2,if(len(trim(v2))= 0,v1,v1+v2)) as new;

LOAD * INLINE [

id, v1, v2

1, , 2

2, , 5

3, , 8

4, 12

5, 54

6, 89

7, 55

8,6,8

9,2,3

];

Re: Adding two Table columns

absekrafi — Thu, 05 Apr 2018 07:57:22 GMT

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

Re: Adding two Table columns

absekrafi — Thu, 05 Apr 2018 08:00:02 GMT

Perfect it works very much Gerold.

Re: Adding two Table columns

absekrafi — Thu, 05 Apr 2018 08:02:10 GMT

Thank you very much Gerold. Your solution works.

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