Discussion Board for collaboration related to QlikView Deployment.
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.
Go to Solution.
drop field SeetNo;
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
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.
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:
drop field could do the job.
thank you for your help in give me the link , now i understand how this work , very powerful.
I'm glad it helped!
All not able to work. any advise ?
the syntax should be
drop field SheetNo;