Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

kaldubai
Contributor

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
Contributor

Re: Number format issue in Qliksense.

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

8 Replies
rittermd
Honored Contributor

Re: Number format issue in Qliksense.

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

micheledenardi
Valued Contributor

Re: Number format issue in Qliksense.

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

kaldubai
Contributor

Re: Number format issue in Qliksense.

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
Valued Contributor

Re: Number format issue in Qliksense.

you can use Ceil function


=Ceil( 478.8106 ,0.01 )= 478.82


rittermd
Honored Contributor

Re: Number format issue in Qliksense.

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

micheledenardi
Valued Contributor

Re: Number format issue in Qliksense.

i agree with you

kaldubai
Contributor

Re: Number format issue in Qliksense.

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
Contributor

Re: Number format issue in Qliksense.

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

Community Browser