topic Re: linking different tables in QlikView

linking different tables

Anonymous — Wed, 09 Oct 2013 13:53:05 GMT

Hi All

i am facing a problem with linking the below tables what i am trying to do is when choosing the company BH in Table 1 want this selection to get me the people's name in table 2 in the same hour i.e peoples's name in the company BH

Re: linking different tables

bbi_mba_76 — Wed, 09 Oct 2013 14:42:00 GMT

Hi,

Table1 and Table5 are linked by the Key1 field?

Re: linking different tables

Anonymous — Wed, 09 Oct 2013 16:58:56 GMT

thank you for your reply ....yes they are linked but i want to make another link let me explain more

i need 2 things :

1- get the people's name

2-the name of persons in the company BH

the current links returns the name of the person but not the time (company BH)

Re: linking different tables

jvitantonio — Wed, 09 Oct 2013 17:19:54 GMT

Tamer, can you please post a real example? That diagram doesn't make much sense. You are linking tables with a blank field .

Re: linking different tables

Anonymous — Thu, 10 Oct 2013 08:41:28 GMT

i hope u can understand the below graph

as shown below table 1 3 & 5 are linked together the problem is when i chose the peak hour in table 1 the result is the cells only while i need 2 things the cells and the peak hour .

Re: linking different tables

jvitantonio — Thu, 10 Oct 2013 08:53:14 GMT

Hi, sorry but I don't understand when you say you don't get the peak hour as you are stating that you select the peak hour. If you select the peak hour and you have the cell, then it's fine. If you want ALL the peak hours for a certain cell, then choose the cell...

Re: linking different tables

Anonymous — Thu, 10 Oct 2013 09:48:31 GMT

the problem is that the output is the cells of the zone but in all the available hours not in the peak hour

Re: linking different tables

jvitantonio — Thu, 10 Oct 2013 10:37:29 GMT

Sorry Tamer but it's hard to tell with your diagram. Do you think you can attach your application? You can scramble the data before sending it if you want. J

Re: linking different tables

saumyashah90 — Thu, 10 Oct 2013 10:40:32 GMT

I Would Suggest you to do

Left Join(Table1)

Load * resident Table3;

left join(Table1)

Load * resident Table5;

Drop Table Table3 and Table5;

Load * from Table2 ;