Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP 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
maxgro
MVP
MVP

add text

load

     text(t_item),

     ......

     ;

sql select

     t_item

     .....

     ;

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi, try converting the field to text in QlikView. Also you can concatenate some "dummy symbol/letter" which can later be deleted:

'_' & text(your_field) as your_field

regards

Not applicable
Author

Doesn't work to convert to TEXT

Not applicable
Author

your way work it BUT we have maannyyy aplications for example if I need to make an JOIN with two tables then I need to do for fact table the same put '_' & text(your_field) as your_field and I am taking just tow tables...and we have manyyyy tables with joins but thanks for your idea....

Not applicable
Author

Some other idea?

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

try converting to text and also concatenating a null character:

chr(0) & text(your_field) as your_field)

maxgro
MVP
MVP

strange as I use it in a lot of load script for the same reason

is it the first load of t_item field?

eduardo_sommer
Partner - Specialist
Partner - Specialist

Hi Omar,

Your SQL result shows two records with the codes 061277 and 61277 and both records in the qlikview table have 61278 as t_item. They are not the same. Maybe you selected the wrong records in the qlikview app.

Is t_item unique in your database, since you have differnt t_dsca for the same t_item?

Eduardo

jaimeaguilar
Partner - Specialist II
Partner - Specialist II

Hi,

Eduardo is right, in the first picture the t_item that appear are:

  • 061277
  • 61277

then in the second screenshot the t_item is 61278. Even descriptions for those items are different.

Could you please confirm that converting to text is not working for you?

regards