Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to tell QV only link certain filed ?

Hi All

I have 2 Table , i only want to link the "ref.no" field.

Now it link up many field which i don't want .

may i know how to force QV to link only ref.no field ?

The reason is for both table i have read all the field into QV , and instead of rename the both table field name not the same , it is a bit trouble some , may be some one have better solution.

Paul

1 Solution

Accepted Solutions
saumyashah90
Specialist
Specialist

try

drop field SeetNo;

View solution in original post

13 Replies
Not applicable
Author

For get to mentioned that for example date at quotation table refer to quote date and date at inquiry table is refer as inquiry date , both date are diff.

saumyashah90
Specialist
Specialist

yes it is possible by keeping the table detached

Not applicable
Author

Hi Sau

Thank you for your response

I try to rename my inquiry table name and it work fine now.

Now my issue is how to tell QV drop field name ? i aware can drop table , but not so sure how to drop field name.

Paul

salto
Specialist II
Specialist II

Hi,

As far as I know renaming the fields is the way to unlink them. Qlikview will link all the fields with the same name.

You could also qualify the fielkd names you do not want to link.

Qualify statements renames all the fields with the table name prefix which are mentioned in the statement. Unqualify is the reverse process:

community.qlik.com/thread/29254

Regards,

salto
Specialist II
Specialist II

Hi,

drop field could do the job.

Not applicable
Author

Hi SALTO

thank you for your help in give me the link , now i understand how this work , very powerful.

Paul

salto
Specialist II
Specialist II

Hi Paul,

I'm glad it helped!

Not applicable
Author

Hi Salto

I try

drop SheetNo

drop SheetNo;

drop SheetNo:

All not able to work. any advise ?

Paul

salto
Specialist II
Specialist II

Hi,

the syntax should be

     drop field SheetNo;


Regards!