Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Number formating Four zeros after decimal

Hi

We have a table containg some cost. Everything is fine , but there is a record containing for zeros after decimal (52,771.0000), what qlikview is doing that it automatically add two zeros before decimal hence corrupting the data.(I am just displaying the cost in a table box)

How can i have the number in its original format.

Thanks & Regards

14 Replies
Sokkorn
Master
Master

Hi,

See sample NUM function below:

     NUM(1234,'#,###.##')         ==> 1,234.00

     NUM(1234,'#,###.####')     ==> 1,234.0000

Let try with your case.

Regards,

Sokkorn

Not applicable
Author

thanks sokkorn
i tried ur solution while loading from the database .. but it still doing the same .. transfering two zeros after the decimal to before decimal.
and if there is 3 zeros after the decimal it is transfering 1 to the right.. in any case it automaticaly fixing two zeros after the decimal

Sokkorn
Master
Master

Hi,

Use this one NUM(NUM#('1,234.00'),'#,###.####')

Not applicable
Author

nope.. not working
do i need to change any setting??

Sokkorn
Master
Master

Hi,

I think no. Can you provide sample data?

Regards,

Sokkorn

Not applicable
Author

table.PNG

SunilChauhan
Champion
Champion

CHART PROPERTIES----> NUMBER-> SELECT eXTERNAL PRICE-> FIXED TO 4

HOPE THIS HELPS

Sunil Chauhan
Not applicable
Author

i dont have any such option in NUMBER property
My Qlikview version is 11

SunilChauhan
Champion
Champion

go to chart properties ->............ Number

it's there

Sunil Chauhan