Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Pragna
New Contributor III

Rounding value Issue

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

22

19

16

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

Any Suggestions/help is appreciated.

Thanks.

 

Tags (2)
Labels (1)
14 Replies
MVP & Luminary
MVP & Luminary

Re: Rounding value Issue

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

Try this?

Round([Days Coverage])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Highlighted
Pragna
New Contributor III

Re: Rounding value Issue

No, It's Not working 

Pragna
New Contributor III

Re: Rounding value Issue

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

Re: Rounding value Issue

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

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Pragna
New Contributor III

Re: Rounding value Issue

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
MVP & Luminary
MVP & Luminary

Re: Rounding value Issue

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

Ref: I misunderstand the requirement.

Capture.PNG

 

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
MVP & Luminary
MVP & Luminary

Re: Rounding value Issue

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