Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
yes it is possible by keeping the table detached
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
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,
Hi,
drop field could do the job.
Hi SALTO
thank you for your help in give me the link , now i understand how this work , very powerful.
Paul
Hi Paul,
I'm glad it helped!
Hi Salto
I try
drop SheetNo
drop SheetNo;
drop SheetNo:
All not able to work. any advise ?
Paul
Hi,
the syntax should be
drop field SheetNo;
Regards!