Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

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
Valued Contributor

Re: How to tell QV only link certain filed ?

try

drop field SeetNo;

13 Replies
Not applicable

Re: How to tell QV only link certain filed ?

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
Valued Contributor

Re: How to tell QV only link certain filed ?

yes it is possible by keeping the table detached

Not applicable

Re: How to tell QV only link certain filed ?

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
Valued Contributor II

Re: How to tell QV only link certain filed ?

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
Valued Contributor II

Re: How to tell QV only link certain filed ?

Hi,

drop field could do the job.

Not applicable

Re: How to tell QV only link certain filed ?

Hi SALTO

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

Paul

salto
Valued Contributor II

Re: How to tell QV only link certain filed ?

Hi Paul,

I'm glad it helped!

Not applicable

Re: How to tell QV only link certain filed ?

Hi Salto

I try

drop SheetNo

drop SheetNo;

drop SheetNo:

All not able to work. any advise ?

Paul

salto
Valued Contributor II

Re: How to tell QV only link certain filed ?

Hi,

the syntax should be

     drop field SheetNo;


Regards!

Community Browser