"Qualify" Statement.

[#1]

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!

[rajeshvaswani77]

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

[jagan]

Hi,

Table1:

LOAD

A,

B

FROM DataSource;

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

Qualify *;

Table1:

LOAD

A,

B

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.

[#4]

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

[#5]

Hi,

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

Regards

Przemek

[#6]

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

[jagan]

Hi,

Change the Label value to the required value.

Regards,

Jagan.

[#8]

Thanks for the tip!!

[#9]

Hi Jagan,

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

here it is,

[#10]

Hi Jagan,

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

here it is,