topic Re: Qualify and Unqualify in Synthetic keys in QlikView

Qualify and Unqualify in Synthetic keys

Thu, 10 Jul 2014 06:06:11 GMT

Hello,

Please provide me the best Example for Qualify and Unqualify along with the data,and as well Info load and it would be great.

Thanks in Advance

Thanks,

Vishnu

Re: Qualify and Unqualify in Synthetic keys

avinashelite — Thu, 10 Jul 2014 06:14:48 GMT

Hi Vishnu,

if your data is huge and has lot of fields which are in common , then we opt for qualify which will make all our fields unique. Every field name will get name like tablename.fieldname , this will load all the table independently without any link between the table.

Later if u want to link this table use UNQUALIFY field name which will link the tables using this fieldname.

Please find the attachment, which will help u to understand more.

Re: Qualify and Unqualify in Synthetic keys

Thu, 10 Jul 2014 06:18:40 GMT

Hi Avinash,

Thanks for your response . It will be helpful if you have any example could you please share.

Thanks in Advance

Thanks,

Vishnu

Re: Qualify and Unqualify in Synthetic keys

jagan — Thu, 10 Jul 2014 06:27:03 GMT

Hi,

Normally column names in Qlikview would be the Column name in a database total, if you want to change that pattern to TableName.FieldName then you can use QUALIFY, to qualify all columns or particular columns in a table. Refer Qlikview help file for more details. Generally this technique is use to avoid Synthetic keys and circular loops.

For Info load check below thread, generally this load is used to bundle the resources like images along with the Dashboard.

Bundle Info Load

Regards,

Jagan.

Re: Re: Qualify and Unqualify in Synthetic keys

avinashelite — Thu, 10 Jul 2014 06:29:32 GMT

Sample