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

Announcements
Join us in Bucharest on Sept 18th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
bhavikumehta
Contributor III
Contributor III

Field values change when QVD stored in Local machine vs QVD stored in QV server

We have a few Materials, for instance, 64650000000 and 64780000000 stored in MS SQL DB

Scenario 1: Pull Materials from MS SQL server table. Store in QVD locally. Pull Materials from this QVD. Materials displayed in Dashboard are as:

 64650000000 and 64780000000

Scenario 1: Pull Materials from MS SQL server table. Store in QVD on QV server. Pull Materials from this QVD. Materials displayed in Dashboard are as:

646500E5 and 647800E5

What difference does it make when data is stored in QVD saved locally and when data is stored in QVD saved on QV server?

Labels (2)
1 Reply
Gysbert_Wassenaar
Partner - Champion III
Partner - Champion III

The only difference is the number formatting. The numbers are the same. 64650000000 is 646500 * 100000 which can also be written as 646500E5.


talk is cheap, supply exceeds demand