topic Re: issue on number format in QlikView

issue on number format

chinnu123 — Mon, 14 Sep 2015 21:44:34 GMT

Hi community,

I created a double header in pivot table as per my requirement and now my issue is the number format for fields is not exact values they are in decimal format i need them in number format...

Example field ATT THE VALUE is 100.042,709636 instead of 100,043

ADS VALUE IS 1.152,778,40893 instead of 1,152,778

DDS VALUE IS 0,0398500258516 instead of 4%

I am attaching my qvw file can any one please look in to that and give me the solution how to resolve this

Thanks in advance

Re: issue on number format

robert_mika — Mon, 14 Sep 2015 22:34:00 GMT

Change setting in script to

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='€#,##0.00;-€#,##0.00';

Re: issue on number format

chinnu123 — Mon, 14 Sep 2015 22:37:47 GMT

Hi Robert,

Its not working

Re: issue on number format

Anonymous — Mon, 14 Sep 2015 22:52:09 GMT

You just should change the number formats.

Re: issue on number format

chinnu123 — Mon, 14 Sep 2015 22:55:51 GMT

Hi Jannet,

please once see the my attached qvw i used double header format so its not possible in my case

Thanks in advance

Re: issue on number format

qlikviewwizard — Tue, 15 Sep 2015 02:12:07 GMT

Hi,

Please check this.

Reason for this issue is- thousand separator should be comma instead of dot,decimal should be dot instead of comma.

Hope this will help.

Re: issue on number format

robert_mika — Tue, 15 Sep 2015 04:32:41 GMT

qliviewwizard is right.

His solution works for me

Feeling Qlikngry?

How To /Missing Manual(18 articles)

Re: issue on number format

qlikviewwizard — Wed, 16 Sep 2015 01:20:08 GMT

Hi Chinnu,

Did you able to resolve the issue?

Re: issue on number format

chinnu123 — Wed, 16 Sep 2015 17:17:21 GMT

No, its not working for me

Re: issue on number format

Wed, 16 Sep 2015 17:28:11 GMT

is this the correct format? (looks lik based on your description above)

Re: issue on number format

Wed, 16 Sep 2015 17:40:44 GMT

I just noticee that one field you wanted as a percent

the sample attached was accomplished by using chart properties as mentioned above. since all of your data is not in the same format but is represented via a single express, that may not be the ultimate solution.

You may need to sue an If function in your expression to format based on field

Re: issue on number format

Wed, 16 Sep 2015 17:45:42 GMT

Hi,

i expect qlick does not intepret these values as numbers.

Firstly use setting

SET ThousandSep=',';

SET DecimalSep='.';

SET MoneyThousandSep=',';

SET MoneyDecimalSep='.';

SET MoneyFormat='€#,##0.00;-€#,##0.00';

as Robert Mika mentioned above.

Then loading data from data source change values to numbers using :

num#(replace(replace( Field , '.' , '' ), ',' , '.' ))

Then you will be able to format data any way you like.

Re: issue on number format

qlikviewwizard — Thu, 17 Sep 2015 01:15:42 GMT

Hi Chinnu,

Please check this file. If you still getting the same issue, attach your sample file.

Re: issue on number format

chinnu123 — Thu, 17 Sep 2015 22:46:16 GMT

Hi qlikviewwizard,

Thanks for showing more interest on resolving my issue..

I am attaching my excel sheet which is the exact values that i want to represent exact values in qlik once please have a look

Re: issue on number format

qlikviewwizard — Fri, 18 Sep 2015 00:39:27 GMT

Hi Chinnu,

Please check the attached file.

Reason for this issue is number format.

Existing Value separater - Decimal is comma, thousands is dot.

I have changed the value separater - Decimal is dot, thousands is comma for all the numbers. Even Percentage too.

Hope this will help you.

Please select Correct and Helpful Answers to close the thread.