topic Re: Exclu Value - LOAD in QlikView

Exclu Value - LOAD

Thu, 17 Jan 2013 13:03:43 GMT

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

Re: Exclu Value - LOAD

giakoum — Thu, 17 Jan 2013 13:24:55 GMT

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

Re: Exclu Value - LOAD

Thu, 17 Jan 2013 13:34:41 GMT

Hi Loannis,

Thank you for your answer.

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

Best Regards,

Yousseff

Re: Exclu Value - LOAD

martin59 — Thu, 17 Jan 2013 14:09:06 GMT

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

Re: Exclu Value - LOAD

martin59 — Thu, 17 Jan 2013 14:09:08 GMT

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

Re: Exclu Value - LOAD

martin59 — Thu, 17 Jan 2013 14:09:11 GMT

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

Re: Exclu Value - LOAD

martin59 — Thu, 17 Jan 2013 14:09:14 GMT

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

Re: Exclu Value - LOAD

martin59 — Thu, 17 Jan 2013 14:09:16 GMT

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

Re: Exclu Value - LOAD

martin59 — Thu, 17 Jan 2013 14:09:19 GMT

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

Re: Exclu Value - LOAD

martin59 — Thu, 17 Jan 2013 14:09:35 GMT

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

Re: Exclu Value - LOAD

Thu, 17 Jan 2013 14:23:50 GMT

Hi,

Thanks for you answer.

Text(Field1) dosen't work for me.

I try this solution but is still me problem.

Best Regards,

Yousseff