topic Re: database values do not coincide with qlikview values in QlikView

database values do not coincide with qlikview values

Mon, 26 Jan 2026 18:19:17 GMT

Hello

I have a field (id_Personal) with values 08, 06, 03 to pass to qlikview I get 8,006,003.

Use the following syntax:
OLEDB CONNECT TO [Provider = SQLOLEDB.1; Persist Security Info = True; User ID = qlikview; Initial Catalog = Storage, Data Source = melodepo; Use Procedure for Prepare = 1; Auto Translate = True; Packet Size = 4096; Workstation ID = SRVQLIKVIEW; Use Encryption for Data = False; Tag with column collation When possible = False] (XPassword is OKNSdQRMNLaADbEGQRPB);

LOAD "Id_Compania"
"Fecha_Transaccion", "Id_Personal"
EmpCod;
SQL SELECT *
FROM Deposito.dbo. "Historico_Movimiento_Encab"
Where year (Fecha_Transaccion)> = 2013;

how to make passes exactly the same values.

Please help,

Rolando

Re: database values do not coincide with qlikview values

nilesh_gangurde — Mon, 22 Apr 2013 18:59:04 GMT

the above syntax for the select query will give error.

instaed of that you fetch all the data from data base and then apply filter(i.e. where condition)

then your script will be.

TEMP:

SQL SELECT *

FROM Deposito.dbo. "Historico_Movimiento_Encab";

TEMP2:

load

"Id_Compania"

"Fecha_Transaccion", "Id_Personal"

EmpCod

resident TEMP

Where year (Fecha_Transaccion)> = 2013;

Drop table TEMP;

-Nilesh

Re: database values do not coincide with qlikview values

Mon, 22 Apr 2013 22:39:10 GMT

I keep sending the same values:

08 - 008

06 - 006

help me

Re: database values do not coincide with qlikview values

Mon, 22 Apr 2013 23:04:06 GMT

In your load statement, use the text() function as shown below to let QV grab all variances of numeric values as text:

text(Id_Personal) as Id_Personal,

Re: database values do not coincide with qlikview values

Mon, 22 Apr 2013 23:10:02 GMT

Different values in an original database and in qvd - why?

Re: database values do not coincide with qlikview values

Tue, 23 Apr 2013 12:33:09 GMT

when shifting out

008 instead of 08,

003 instead of 03.

006 instead of 06

because that happens if copied directly from a database

Re: database values do not coincide with qlikview values

danielrozental — Tue, 23 Apr 2013 12:56:18 GMT

Values are being interpreted as numbers by qlikview. You should force the value to be read as text.

LOAD "Id_Compania"

"Fecha_Transaccion",

text("Id_Personal") AS Id_Personal,

EmpCod;

SQL SELECT *

FROM Deposito.dbo. "Historico_Movimiento_Encab"

Where year (Fecha_Transaccion)> = 2013;

Re: database values do not coincide with qlikview values

er_mohit — Tue, 23 Apr 2013 13:08:16 GMT

use field in [] bracket like this

[ "Id_Compania"]

[ "Fecha_Transaccion"], text([ "Id_Personal"])as [ "Id_Personal"]

hope it helps

Re: database values do not coincide with qlikview values

Tue, 23 Apr 2013 13:50:40 GMT

hello

to use [] does not recognize fields

help me

Re: database values do not coincide with qlikview values

Clever_Anjos — Tue, 23 Apr 2013 14:18:09 GMT

Try

LOAD "Id_Compania"

"Fecha_Transaccion",

num("Id_Personal",'00') as Id_Personal, // Or 000 if you want 3 digits

EmpCod;

SQL SELECT *

FROM Deposito.dbo. "Historico_Movimiento_Encab"

Where year (Fecha_Transaccion)> = 2013;

Re: database values do not coincide with qlikview values

Clever_Anjos — Tue, 23 Apr 2013 14:20:04 GMT

Maybe you need trim values, so use this

LOAD "Id_Compania"

"Fecha_Transaccion",

num(trim("Id_Personal"),'00') as Id_Personal, // Or 000 if you want 3 digits

EmpCod;

SQL SELECT *

FROM Deposito.dbo. "Historico_Movimiento_Encab"

Where year (Fecha_Transaccion)> = 2013;

Re: database values do not coincide with qlikview values

Tue, 23 Apr 2013 15:26:11 GMT

After doing tests with the recommendations, I still have the same problem described:

the field in the database is 3 digits, may have id_personal with 2 or 3 digits, for example:

Table Historico_Encab(database) Qlikview Tabla_Personal(database)

Id_Personal: 08 008 08

06 006 06

are not equal: qlikview(Tabla historico_Encab) and tabla_personal:

Helpme please

Re: database values do not coincide with qlikview values

Tue, 23 Apr 2013 18:22:04 GMT

thank you all for the cooperation

topic Re: database values ​​do not coincide with qlikview values in QlikView

database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

Re: database values ​​do not coincide with qlikview values

topic Re: database values do not coincide with qlikview values in QlikView

database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values

Re: database values do not coincide with qlikview values