topic Qlikview Join , scenario in QlikView

Qlikview Join , scenario

sujit_nath — Sat, 16 Nov 2024 01:47:20 GMT

I have two tables in a way that Table 1 has columns A,B,C,D,E and Table 2 has Columns A,Q,R,S,T. In Qlikview table viewer, they are connected on Column A (Not join). Now I have got a third table, Table 3 with column B and Q. I want to show the data in the dashboard which would match B and Q combination from table 3.

How should I achieve that? I somehow implemented that using lot of joins and drops, but is there an easy way? How should I implement this with right join?

Re: Qlikview Join , scenario

martinpohl — Wed, 04 Dec 2019 08:57:36 GMT

Hi,

you need to join the tables because if you are loading them without you will get a circular reference.

What kind of join (left, right, inner outer) is depending on which datas you want. Is there a master table?

Regards

Re: Qlikview Join , scenario

zhadrakas — Wed, 04 Dec 2019 09:14:03 GMT

if table 3 has only B and Q you can go like

Load * from Table3; left join Load * from Table 2; left join Load * from Table 1;

EDIT: didnt see that you want to keep Table 1 and 2 seperate

3: Load * from Table 3; 2: Load * from Table 2 where exists(Q); 1: Load B,C,D,E from Table 1 where exists(A) AND exists(B);

regards

tim

Re: Qlikview Join , scenario

Brett_Bleess — Wed, 11 Dec 2019 16:33:15 GMT

Did Tim's post get you a working solution for your use case? If so, be sure to come back to the thread and use the Accept as Solution button on his post to give him credit for the assistance and to let other Community Members know this worked for the use case.

The only place I could point you to try to find some other ideas is the Design Blog area, here is the base URL, you can search yourself, as I was not exactly sure what you needed on this one, but I suspect you can find some posts that may be of some help to you. I generally start with a single term, see what pops up and then use other words from that first search to narrow things down etc.

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett