i have a question. I'm import a SharePoint list. I have a German System in my QliKView with the default variables. I maked a Num# on the sum fields and then i get something like this:
NUM#(Umsatz_Jan) as Umsatz_Jan,
All Numbers with a minus before or the number with an comma are text formatted and the other all correct with number format. How can i get them together so that in the script all are a number? Thank you for your help.
thank you for your help. I tried both solution. Here the result:
The resut from settu keep the format, that is ok. But i want that all of them are numbers, so they should be on the right sight. I don't know how to realize this in the script. Maybe you have also an idea?