Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, i tried to read from an txt, a couple of rows with this :
111222333444555
999888777666555
The problem is that qlikview recognized those rows as text, and a simple aggregation as sum doesnt work.
if i try with :
11122233344455
99988877766655
Qlikview recognized them as numbers and de aggregations works fine.
any ideas??
my customer wants and needs to read this kind of data.
thanks ind advance
Try reading them in as numbers. You can do this by enclosing the field with the num() function in the load script. For example:
num(myfieldname) as myfieldname,
Regards,
Hi Fabian,
unfortunately "Num" will not work if your numbers have more than 14ten digits.
Now "Evaluate" comes in place. But here no decimals are allowed (111111,11).
I send a second example for a workaround.
Good luck!
Rainer
Hi Fabian,
here are the second one using "Evaluate" , "SubField" and decimals.
Rainer