Discussion Board for collaboration on QlikView Scripting.
i have two or three excel table in which UserID is only common field.in tableA there is a column EMP_Designation but not in other two
but i want to use this EMP_Designation in filter of tableB and TableC so is it possible to use it in tableB and C as only UserID is the only common field..
As QlikView works on associate model.
Yes this will work.
Only one common key is required to reach to your solution in all excel sheets , which in your case is UserID .
This should work.
Ashfaque Ahmad thanx for ur quick responce,can u tell for this what should i do..
As Qlik Joins on same field name.
Make sure your common key have same name in all tables or you can alias them while loading.
Attachment will help you to understand join function.
If members were able to answer to your question. Please find the best answer and mark this question as answered or helpful.
Have a look to the following document for asking question over the qlikview community.
Ways to Ask Questions with QlikView