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: 
kaldubai
Creator
Creator

Number format issue in Qliksense.

Hello Community.

Capture.PNG

i am trying to get the value of (QTY * item-Cost ) which in this case its (2 * 239.410)=478.82 but its showing 478.8106.

having in mind that the item cost before formatting is 239.4051 and after its formatted in the back end ,using num''##.##0'' 239.41

any suggestion would be appreciated.

1 Solution

Accepted Solutions
kaldubai
Creator
Creator
Author

hello All ,

I thank each one of you for your valuable suggestion.

I came to find a solution for my Problem. for some reason QLIKSENSE was ignoring the formatting of the item cost even though it was done in the script. so my workaround was to force the item cost format while fetching from the database as I am fetching data from Oracle .


Sincerely

View solution in original post

8 Replies
rittermd
Master
Master

Change the format of the field in the properties from Auto to Number with 2 decimal places.

micheledenardi
Specialist II
Specialist II

Have you already tried to use the measure formatting options from the chart menù?

2017-10-31 16_05_39-KS SSV IT Activities(Sviluppo) - Dashboard _ Fogli - Qlik Sense.png

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
kaldubai
Creator
Creator
Author

it Shows 478.81

Im assuming its taking cost before formatting for some reason

anyway we can round this 478.8106 to 478.82



micheledenardi
Specialist II
Specialist II

you can use Ceil function


=Ceil( 478.8106 ,0.01 )= 478.82


Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
rittermd
Master
Master

By default I would think that 478.8106 would round to 478.81 and not 82

micheledenardi
Specialist II
Specialist II

i agree with you

Michele De Nardi
If a post helps to resolve your issue, please accept it as a Solution.
kaldubai
Creator
Creator
Author

I honestly think the same..but if i change the format of item cost to ##.##0 which makes it 239.41 and when multiply that by 2 it should show 478.82 not 478.8106

As shown in the picture..

kaldubai
Creator
Creator
Author

hello All ,

I thank each one of you for your valuable suggestion.

I came to find a solution for my Problem. for some reason QLIKSENSE was ignoring the formatting of the item cost even though it was done in the script. so my workaround was to force the item cost format while fetching from the database as I am fetching data from Oracle .


Sincerely