Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Tags (5)
7 Replies
mwoolf
Honored Contributor II

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

What values are in Bedrag?

Not applicable

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

currency in Euro.

Bedrag.bmp

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

HI

     Use Num(@5) as Bedrag

     Instead Num#(@5) as Bedrag

Hope it helps


Not applicable

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

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

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

HI

     Can you post the sample input file ?

Not applicable

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

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
Valued Contributor III

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

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

Community Browser