Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

Re: HI

As QlikView works on associate model.

Yes this will work.

Regards

ASHFAQ

amit_saini
Honored Contributor III

Re: HI

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

Re: HI

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

Re: HI

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
Honored Contributor III

Re: Re: HI

Attachment will help you to understand join function.

Thanks,

AS

Not applicable

Re: Re: HI

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

Not applicable

Re: HI

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

Not applicable

Re: HI

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
Valued Contributor III

Re: HI

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

Community Browser