Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

HI

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..

9 Replies
ashfaq_haseeb
Champion III
Champion III

As QlikView works on associate model.

Yes this will work.

Regards

ASHFAQ

amit_saini
Master III
Master III

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

Not applicable
Author

Ashfaque Ahmad thanx for ur quick responce,can u tell for this what should i do..

ashfaq_haseeb
Champion III
Champion III

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

amit_saini
Master III
Master III

Attachment will help you to understand join function.

Thanks,

AS

Not applicable
Author

Thanks........its working.........

Not applicable
Author

Thankss............

Not applicable
Author

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

engishfaque
Specialist III
Specialist III

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