Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HELLO FRIENDS...
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.
Regards
ASHFAQ
Ashish,
Only one common key is required to reach to your solution in all excel sheets , which in your case is UserID .
This should work.
Thanks,
AS
Ashfaque Ahmad thanx for ur quick responce,can u tell for this what should i do..
Hi,
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.
That's it.
Regards
ASHFAQ
Attachment will help you to understand join function.
Thanks,
AS
Thanks........its working.........
Thankss............
Hello Ashish,
If members were able to answer to your question. Please find the best answer and mark this question as answered or helpful.
Thanks,
Singh
Dear Ashish,
Have a look to the following document for asking question over the qlikview community.
Ways to Ask Questions with QlikView
Kind regards,
Ishfaque Ahmed