How can we break link between tables in Qlikview?

qlikview
#1

Hi all,

Due to associate technology, Qlikview automatically links tables based on the name of variable. Can you suggest me the methods to break these links between tables and How can I manually establish a link between tables.

Thanks,
Karan

#2

@Karan,

You can break link between two tables by following methods:-

  • Renaming of fields: Renaming can be done by using “AS” clause.

  • Using Qualify: We can also achieve this by using QUALIFY statement. With qualified statement, fields names are converted in the “TableName.FieldName” format.

Qlik_View_Synthetic_Keys.png966×278 12.2 KB

Hope this helps!

Regards,
Sunil