Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Try this?
Round([Days Coverage])
No, It's Not working
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
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
Ref: I misunderstand the requirement.
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