Discussion board where members can get started with Qlik Sense.
I have a field that is text that I would like to convert to a number so I can do conditional formatting. The values in the field are formatted like this:
How can I convert this to a number and strip out the -'s and +'s so I can do conditional formatting?
If I understood correctly, one solution :
load *,num(keepchar(Field,'0123456789')) as FormatedField inline [
but if you want to keep '-'