Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

adhpco16
New Contributor III

Sum Field have text and number format

Hello to all of you,

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,

text.JPG

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.

Kind Regards

5 Replies
arulsettu
Honored Contributor III

Re: Sum Field have text and number format

try this

text(NUM#(Umsatz_Jan)) as Umsatz_Jan,

hrlinder
Honored Contributor

Re: Sum Field have text and number format

try this Expression and you may put a num around to Format to your requirements

num#(PurgeChar(Umsatz_Jan,',.'))

adhpco16
New Contributor III

Re: Sum Field have text and number format

Hello,

thank you for your help. I tried both solution. Here the result:

Text2.JPG

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?

Kind Regards

adhpco16
New Contributor III

Re: Sum Field have text and number format

Now i only need this as number.

hrlinder
Honored Contributor

Re: Sum Field have text and number format

as I wrote you may use num function

=num(num#(PurgeChar(Umsatz_Jan,',.')),'#.##0')