Exclu Value - LOAD

[#1]

Hi All,

I my database i have Field as varchar(n) with this value :

Field
000002
00000002
12031589

When i load this field into QlikView i have only tow value "00000002" and "12031589"

Please, can everyone explain my this why QlikView exclu "000002"

Best Reagrads,

Yousseff

[giakoum]

Hi.

Qv does not exclude this value. If you preview the table, it is there, but it is "converted" to "00000002". Actually it is converted to which value of the two loads first. Most like they have the same binary representation, that is why it is happening.

Try putting a string character in front them, load them and then remove the character in your calculations. Not a very elegant solution, I am afraid...

[#3]

Hi Loannis,

Thank you for your answer.

I will try your solution and advice you if its works.

Best Regards,

Yousseff

[martin59]

Hi Youssef,

QlikView does not exclude values. To exlude values, you have to use the WHERE keyword.

Here, you keep all datas, but QlikView change format from text to numeric. So the result for your two first lines is 2.

In you load script (File / Edit Script), you must have something like that :

LOAD Field1,

     Field2,

     ...,

     Field

FROM Data.qvd (qvd);

if it's right, you just have to change your script like that

LOAD Field1,

     Field2,

     ...,

     Text(Field) as Field

FROM Data.qvd (qvd);

Next, Reload your app and you should have three distinct values.

Hope that helps you,

Martin Favier

[martin59]

Hi Youssef,

QlikView does not exclude values. To exlude values, you have to use the WHERE keyword.

Here, you keep all datas, but QlikView change format from text to numeric. So the result for your two first lines is 2.

In you load script (File / Edit Script), you must have something like that :

LOAD Field1,

     Field2,

     ...,

     Field

FROM Data.qvd (qvd);

if it's right, you just have to change your script like that

LOAD Field1,

     Field2,

     ...,

     Text(Field) as Field

FROM Data.qvd (qvd);

Next, Reload your app and you should have three distinct values.

Hope that helps you,

Martin Favier

[martin59]

Hi Youssef,

QlikView does not exclude values. To exlude values, you have to use the WHERE keyword.

Here, you keep all datas, but QlikView change format from text to numeric. So the result for your two first lines is 2.

In you load script (File / Edit Script), you must have something like that :

LOAD Field1,

     Field2,

     ...,

     Field

FROM Data.qvd (qvd);

if it's right, you just have to change your script like that

LOAD Field1,

     Field2,

     ...,

     Text(Field) as Field

FROM Data.qvd (qvd);

Next, Reload your app and you should have three distinct values.

Hope that helps you,

Martin Favier

[martin59]

Hi Youssef,

QlikView does not exclude values. To exlude values, you have to use the WHERE keyword.

Here, you keep all datas, but QlikView change format from text to numeric. So the result for your two first lines is 2.

In you load script (File / Edit Script), you must have something like that :

LOAD Field1,

     Field2,

     ...,

     Field

FROM Data.qvd (qvd);

if it's right, you just have to change your script like that

LOAD Field1,

     Field2,

     ...,

     Text(Field) as Field

FROM Data.qvd (qvd);

Next, Reload your app and you should have three distinct values.

Hope that helps you,

Martin Favier

[martin59]

Hi Youssef,

QlikView does not exclude values. To exlude values, you have to use the WHERE keyword.

Here, you keep all datas, but QlikView change format from text to numeric. So the result for your two first lines is 2.

In you load script (File / Edit Script), you must have something like that :

LOAD Field1,

     Field2,

     ...,

     Field

FROM Data.qvd (qvd);

if it's right, you just have to change your script like that

LOAD Field1,

     Field2,

     ...,

     Text(Field) as Field

FROM Data.qvd (qvd);

Next, Reload your app and you should have three distinct values.

Hope that helps you,

Martin Favier

[martin59]

Hi Youssef,

QlikView does not exclude values. To exlude values, you have to use the WHERE keyword.

Here, you keep all datas, but QlikView change format from text to numeric. So the result for your two first lines is 2.

In you load script (File / Edit Script), you must have something like that :

LOAD Field1,

     Field2,

     ...,

     Field

FROM Data.qvd (qvd);

if it's right, you just have to change your script like that

LOAD Field1,

     Field2,

     ...,

     Text(Field) as Field

FROM Data.qvd (qvd);

Next, Reload your app and you should have three distinct values.

Hope that helps you,

Martin Favier

[martin59]

Hi Youssef,

QlikView does not exclude values. To exlude values, you have to use the WHERE keyword.

Here, you keep all datas, but QlikView change format from text to numeric. So the result for your two first lines is 2.

In you load script (File / Edit Script), you must have something like that :

LOAD Field1,

     Field2,

     ...,

     Field

FROM Data.qvd (qvd);

if it's right, you just have to change your script like that

LOAD Field1,

     Field2,

     ...,

     Text(Field) as Field

FROM Data.qvd (qvd);

Next, Reload your app and you should have three distinct values.

Hope that helps you,

Martin Favier