topic Re: Re: HI in QlikView

HI

Tue, 26 Aug 2014 13:17:38 GMT

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

Re: HI

ashfaq_haseeb — Tue, 26 Aug 2014 13:22:08 GMT

As QlikView works on associate model.

Yes this will work.

Regards

ASHFAQ

Re: HI

amit_saini — Tue, 26 Aug 2014 13:24:06 GMT

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

Re: HI

Tue, 26 Aug 2014 13:25:46 GMT

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

Re: HI

ashfaq_haseeb — Tue, 26 Aug 2014 13:27:36 GMT

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

Re: Re: HI

amit_saini — Tue, 26 Aug 2014 13:40:15 GMT

Attachment will help you to understand join function.

Thanks,

Re: Re: HI

Fri, 12 Sep 2014 04:23:09 GMT

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

Re: HI

Fri, 12 Sep 2014 04:23:28 GMT

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

Re: HI

Fri, 12 Sep 2014 07:08:14 GMT

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

Re: HI

engishfaque — Fri, 12 Sep 2014 07:25:51 GMT

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