topic "Qualify" Statement. in QlikView

"Qualify" Statement.

Tue, 21 Feb 2012 15:57:36 GMT

Hi there!!

i need a little help here, it would be great if someone can explain me how exactly the "Qualify" statement does!

Thank's!

"Qualify" Statement.

rajeshvaswani77 — Tue, 21 Feb 2012 16:04:21 GMT

Hi,

If you say

Qualify *;

This will qualify all the fields such that they are tablename.fieldname

Qualify fieldname;

Will qualify that field name only.

This is to prevent joinining of similar field names which is a nature of qlikview.

If all the fields that we intend to name are aliased with the word Link

example:

Customerid as Link_pk_customer

and then we say

UnQualify Link*;

this will unqualify all these fields since we intend to join them. (All field names starting with Link will not have the name changed to tablename.fieldsname , it will just be fieldname)

thanks,

Rajesh Vaswani

"Qualify" Statement.

jagan — Tue, 21 Feb 2012 16:04:28 GMT

Hi,

Table1:

LOAD

FROM DataSource;

Now the columns in the Table1 are internally represented as A, B.

Qualify *;

Table1:

LOAD

FROM DataSource;

If we use Qualify then the columns in Table1 are internally repersented in Qlikview as Table1.A, Table1.B.

It just renames fieldnames A and B as Table1.A, Table1.B.

Regards,

jagan.

"Qualify" Statement.

Tue, 21 Feb 2012 16:11:27 GMT

Thank for the help and the examples..

Ii used it and it works, now i have one more little issue...

i used a table box to put some information there but now the headers look like this "TableName.FieldName" but i just need the FieldName in the header.

How can i change this?

Thanks.

Regards from Mexico.

Kenneth...

"Qualify" Statement.

Tue, 21 Feb 2012 16:13:54 GMT

Hi,

you can use a straight table instead, where you can change the labels.

Regards

Przemek

"Qualify" Statement.

Tue, 21 Feb 2012 16:14:40 GMT

It seems that you can do the same in table box in preferences (Label).

"Qualify" Statement.

jagan — Tue, 21 Feb 2012 16:16:27 GMT

Hi,

Change the Label value to the required value.

Regards,

Jagan.

"Qualify" Statement.

Tue, 21 Feb 2012 16:20:48 GMT

Thanks for the tip!!

Re: "Qualify" Statement.

Thu, 21 Mar 2013 07:41:10 GMT

Hi Jagan,

I am doing the same, but it has some problem cold you please help me out from this?

here it is,

Re: "Qualify" Statement.

Thu, 21 Mar 2013 09:53:49 GMT

Hi Jagan,

I am doing the same, but it has some problem cold you please help me out from this?

here it is,

Re: "Qualify" Statement.

Thu, 21 Mar 2013 09:54:13 GMT

Hi Jagan,

I am doing the same, but it has some problem cold you please help me out from this?

here it is,