topic Re: QV showing incorrect values - load in QlikView

QV showing incorrect values - load

Wed, 09 Jul 2014 22:56:45 GMT

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

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:

ACTUALLY Show records in QlikView column t_item:

Re: QV showing incorrect values - load

maxgro — Wed, 09 Jul 2014 23:07:47 GMT

add text

load

text(t_item),

......

;

sql select

t_item

.....

;

Re: QV showing incorrect values - load

jaimeaguilar — Wed, 09 Jul 2014 23:08:02 GMT

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

Re: QV showing incorrect values - load

Wed, 09 Jul 2014 23:10:05 GMT

Doesn't work to convert to TEXT

Re: QV showing incorrect values - load

Wed, 09 Jul 2014 23:12:23 GMT

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

Re: QV showing incorrect values - load

Wed, 09 Jul 2014 23:13:00 GMT

Some other idea?

Re: QV showing incorrect values - load

jaimeaguilar — Wed, 09 Jul 2014 23:13:31 GMT

try converting to text and also concatenating a null character:

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

Re: QV showing incorrect values - load

maxgro — Wed, 09 Jul 2014 23:22:38 GMT

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

is it the first load of t_item field?

Re: QV showing incorrect values - load

eduardo_sommer — Wed, 09 Jul 2014 23:41:06 GMT

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

Re: QV showing incorrect values - load

jaimeaguilar — Fri, 25 Jul 2014 23:31:59 GMT

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

Re: QV showing incorrect values - load

qlikoqlik — Sat, 26 Jul 2014 08:20:06 GMT

I have used text while loading it self and it worked

text(Textxx) as xText