Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Note: You may notice some temporary visual or styling issues in the Community. Our vendor is actively investigating.
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Default precision and Scale in Qlikview 11.20

Hi All,

We are loading the data from hive environment to qlikview qvds. we are not having any datatype in the Qlikview datamodel. Now please let me know what will be the default Precision and scale in the Qlikview if I load a decimal data from HIVE into Qlikview column.

Thanks in Advance

1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

There's only one numeric data type in Qlikview and it's the IEEE 754 Floating point. Using the num() function and the Number formatting options in chart objects you can change the displayed scale and precision, but the actual numeric value will still be the same. Formatting doesn't change a numeric value. Rounding does. So if you use the Round(), Floor() or Ceil() functions you do change the value. Perhaps this blog post helps: Rounding Errors


talk is cheap, supply exceeds demand