Discussion Board for collaboration on QlikView Scripting.
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?
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#
(txt, codepage is 1252, explicit labels, delimiter is ',', msq);
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
What values are in Bedrag?
currency in Euro.
Use Num(@5) as Bedrag
Instead Num#(@5) as Bedrag
Hope it helps
I've done that, but it did not work at all.
I got all empty value's
Any other suggestions are highly apriciated.
Can you post the sample input file ?
Here is a sample imput file.
I scrambled the date a bit since it is confedential.
I can sum it with no problem. Check out the app.