topic Re: Number Load Format in App Development

Number Load Format

NemoAndStitch22 — Mon, 15 Jul 2024 14:13:33 GMT

Hiya,

Might be a really simple answer but I can't find anything when I google..

I have a text file that I'm loading in and for some reason the numbers are formatted in brackets for negatives which are then being ignored as they aren't numbers in qlik...

Does anyone know the formula/how to change them to negatives when loading in?

I've tried Num/Num#/replace but I can't get anything to work.

Thanks!!!

Re: Number Load Format

PrashantSangle — Mon, 15 Jul 2024 14:24:35 GMT

Check evaluate ()

https://help.qlik.com/en-US/qlikview/May2024/Subsystems/Client/Content/QV_QlikView/Scripting/StringFunctions/Evaluate.htm

Re: Number Load Format

NemoAndStitch22 — Mon, 15 Jul 2024 14:32:45 GMT

That's just removing the brackets and making everything positive.. Not keeping them as negatives?

Re: Number Load Format

marcus_sommer — Mon, 15 Jul 2024 14:40:10 GMT

You may try: alt(Field, purgechar(Field, '()') * -1)

Re: Number Load Format

NemoAndStitch22 — Mon, 15 Jul 2024 14:53:07 GMT

That just made everything negative.. I've got a mix of positives, think I've found an answer:

num#(Replace(Replace([field], '(', '-'), ')', '')) as [field],