Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP
MVP

Re: QV showing incorrect values - load

add text

load

     text(t_item),

     ......

     ;

sql select

     t_item

     .....

     ;

jaimeaguilar
Valued Contributor II

Re: QV showing incorrect values - load

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

Re: QV showing incorrect values - load

Doesn't work to convert to TEXT

Not applicable

Re: QV showing incorrect values - load

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

Re: QV showing incorrect values - load

Some other idea?

jaimeaguilar
Valued Contributor II

Re: QV showing incorrect values - load

try converting to text and also concatenating a null character:

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

MVP
MVP

Re: QV showing incorrect values - load

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
Valued Contributor

Re: QV showing incorrect values - load

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
Valued Contributor II

Re: QV showing incorrect values - load

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

Community Browser