Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can't do a sum() on the text field...

Hi All,

I've got an issue with a text file I'm importing into my QVW.

Imported the text file in the script; all went well, data is available...

or is it?

Transactions:

LOAD @1 as [Eigen Rekening],

     @2 as Valuta,

     MakeDate(Left(@3,4), Mid(@3,5,2),Mid(@3,7,2)) as [Tranactie Datum],

     @4 as [C-D],

//     Num#(@5) as Bedrag,

     @5 as Bedrag,

     @6 as [Tegen Rekening],

     @7 as Geadresseerde,

     MakeDate(Left(@8,4), Mid(@8,5,2),Mid(@8,7,2)) as Datum,

     @9 as Soort,

     @11 as Omschrijving#1,

     @12 as Omschrijving#2,

     @13 as Omschrijving#3,

     @14 as Omschrijving#4,

     1            as Count#

 

FROM

(txt, codepage is 1252, explicit labels, delimiter is ',', msq);

tabel.bmp

The field Bedrag is must be a numerical field, but I can't seen to change it from text to numerical

I can't do a sum() or Avg() becouse it is a text field.

Please help, tnx a lot

7 Replies
m_woolf
Master II
Master II

What values are in Bedrag?

Not applicable
Author

currency in Euro.

Bedrag.bmp

MayilVahanan

HI

     Use Num(@5) as Bedrag

     Instead Num#(@5) as Bedrag

Hope it helps


Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

Hi Mayil,

I've done that, but it did not work at all.

I got all empty value's

Any other suggestions are highly apriciated.

Bedrag+2.bmp

MayilVahanan

HI

     Can you post the sample input file ?

Thanks & Regards, Mayil Vahanan R
Please close the thread by marking correct answer & give likes if you like the post.
Not applicable
Author

HI Mayil,

Here is a sample imput file.

I scrambled the date a bit since it is confedential.

14xx3x08xEUR20110601D.030Debetrente20110606db
Periode 01-05-2011 t/m 31-05-201



14xx3x08xEUR20110606D12.940XXXXXXXXX XXXXXX XXXXXXX20110606ba
Betaalautomaat 14:10 pasnr. 006



14xx08xx3EUR20110907D32.00943926343XXXXXXXXXXX XXXXXXXX20110907bg
XXXXXXox 2-9-2011groetjes en bedankt


14xx08xx3EUR20110911D70.000ING BANK XXXXXXX 6x3x AT20110912ga
Geldautomaat 13:32 pasnr. 005



18xx1xx40EUR20120903D100.00230108377xExxL LxxVExZ20120903ma
BETALINGSKENM.  286858823360195WINxxX98          POL xxxxxxxxxx1 SEP / 1 OKT

18xx1xx40EUR20120903D125.71230108377xExxL LxxVExZ20120903ma
BETALINGSKENM.  286858853360195WINxxX98          POL xxxxxxxxxx1 SEP / 1 OKT
















jvitantonio
Luminary Alumni
Luminary Alumni

I can sum it with no problem. Check out the app.