topic Re: Rounding value Issue in App Development

Rounding value Issue

Pragna — Sat, 16 Nov 2024 06:45:03 GMT

Hi Experts,

I see an issue with the data pulling to Qlik. The Original Table with SQL has the field value as

Days Coverage

21.7

18.5

16.1

But the same field I have pulled to Qlik and the Days Coverage values are looking like below values

Days Coverage

I haven't not given any Round() function but still it's automatically rounding.

Any Suggestions/help is appreciated.

Thanks.

Re: Rounding value Issue

marcus_sommer — Fri, 25 Jan 2019 15:33:36 GMT

I think there is no rounding else it's a formatting - you could adjust the fieldformat within the properties or you might use something like num(Field, '#,##0.0') by loading the data.

- Marcus

Re: Rounding value Issue

Anil_Babu_Samineni — Fri, 25 Jan 2019 15:36:01 GMT

Try this?

Round([Days Coverage])

Re: Rounding value Issue

Pragna — Fri, 25 Jan 2019 15:40:26 GMT

No, It's Not working

Re: Rounding value Issue

Pragna — Fri, 25 Jan 2019 15:41:43 GMT

Is it something i have to load in Script editor or in the measure???

Re: Rounding value Issue

Anil_Babu_Samineni — Fri, 25 Jan 2019 15:43:13 GMT

Sorry to ask you, Please mention name while replying.

If that question to me, You can use anywhere? Even, Marcus one can be used both side

Re: Rounding value Issue

Pragna — Fri, 25 Jan 2019 15:45:42 GMT

Sorry about the confusion Both.
@MVP : I have used the Round() function it's not working.
@Marcus : I have also used Num() function it's still rounding the value and displaying (Eg : 17.0)

Thanks for the response

Re: Rounding value Issue

marcus_sommer — Fri, 25 Jan 2019 15:48:41 GMT

It depends on your requirements and couldn't be answered in general. If your field is visible within many and/or important listboxes or any chart-dimensions and you need to display a certain number of digits it could be useful to format and/or round the data within the script. If it's only a measure which will be aggregated in some way I wouldn't probably touch it.

- Marcus

Re: Rounding value Issue

Anil_Babu_Samineni — Fri, 25 Jan 2019 15:56:55 GMT

Ref: I misunderstand the requirement.

Re: Rounding value Issue

marcus_sommer — Fri, 25 Jan 2019 15:53:46 GMT

Did you use num() with a specified formatting or just num(Field)? Without specifying any format it will return the format which is defined within the standard-variables. If this don't help just load this field a second time with: text(Field), maybe within a preceeding load to see what is really coming from the database.

- Marcus

Re: Rounding value Issue

Pragna — Fri, 25 Jan 2019 16:00:34 GMT

@MVP : Thank you , But based on the image displayed above it's still rounding the value But what my manager wants is to see the exact Days coverage value without any roundoff.

Re: Rounding value Issue

Anil_Babu_Samineni — Fri, 25 Jan 2019 16:03:21 GMT

As Marcus included, It is something difficult to say without having you done 🙂

BTW, Can you see using Text() function for that? Text() returns same as DB.

Re: Rounding value Issue

Pragna — Fri, 25 Jan 2019 16:04:23 GMT

@MVP ,@Marcus : When i have used the text(Days Coverage) it's still displaying rounding value number.

Re: Rounding value Issue

marcus_sommer — Fri, 25 Jan 2019 16:17:23 GMT

I tend to think that the number don't have any digits when they come into Qlik. Could you compare with other numerical fields which you load from this database with this driver? Does it happens there too or is this the only field?

- Marcus

Re: Rounding value Issue

Pragna — Fri, 25 Jan 2019 16:20:33 GMT

@Marcus : I have compared the other fields as well from the same DB , It seems to be only this particular field that is rounding .