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

Announcements
Join us in NYC Sept 4th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

QV showing incorrect values - load

Hi everyone;

When I load data from SQL to Qlikview doesn't show the information correct in Qlik View for example

if I have a 2 records:

061277

61277

when I load this in qlikview show:

061277

061277

I WAS trying the next and doesn't work:

convert in sql or qlikview to varchar, char, text or money...

also cut characters with function INDEX etc, etc....

CAN YOU HELP PLEASE ANY IDEA?

ACTUALLY Show records in SQL column t_item:

sql2.jpg

ACTUALLY Show records in QlikView column t_item:

qlikview.jpg

10 Replies
qlikoqlik
Creator
Creator

Hi

I have used text while loading it self and it workedText to show leading zero.GIF.gif

text(Textxx) as xText