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

Announcements
Qlik Connect 2026 Agenda Now Available: Explore Sessions
cancel
Showing results for 
Search instead for 
Did you mean: 
lucacrepaldi
Partner - Contributor
Partner - Contributor

Table Fields not correctly imported

I created apps and linked a table via Microsoft SQL server connection.
If I open the table and query with Microsoft SQL Server Management Studio I see a row in the

sid_key column = 8410000000000000010022
If I import the table in Qlik I see

sid_key = 8.41E + 21

In particular, in qlik they are all the same - while in sql the lines are all distincts

 

Labels (1)
1 Reply
teiswamsler
Partner - Creator III
Partner - Creator III

Hi Lucacrepaldi

Try using Evaluate() to force a calculation of the string/number

Br.
Teis