topic Re: Number Format in QlikView

Number Format

Anonymous — Thu, 03 Dec 2015 17:11:37 GMT

I am trying to convert these amounts to money by choosing 'Money' in Number tab in chart properties. Only some of the amounts are getting converted to money while the rest are not. I realized that the numbers having a 'comma' are the ones not getting converted to money. How do I solve this? Please Help.

Re: Number Format

swuehl — Thu, 03 Dec 2015 17:44:16 GMT

Double check the formats of your number separators at the beginning of your script:

SET ThousandSep=',';

SET DecimalSep='.';

If your numbers are parsed correctly, all values should be right aligned in a list box by default.

Re: Number Format

marcus_sommer — Thu, 03 Dec 2015 17:44:46 GMT

It looked that you have a mix of numeric- and string-values in your dimension. In this case you need to make sure that all your values are numeric - this could be done in script by using num#(yourvalue, 'YourFormat') maybe within an if-loop to catch the differences of all their values.

- Marcus

Re: Number Format

Thu, 03 Dec 2015 17:50:17 GMT

Hi Chandni, I think that this happens because some numbers are strings.

So, first of all, convert the strings to numbers and then apply the money format.

To convert strings to number apply this function:

num(Num#([YOUR_VALUE],'###,###.####','.',','),'###,###.##')

I hope that it help you,

Regards,

Agustín

Re: Number Format

Anonymous — Fri, 04 Dec 2015 16:56:01 GMT

Thank You!

Re: Number Format

Anonymous — Fri, 04 Dec 2015 16:56:23 GMT

Thank You!