topic Re: Model Qlikview in QlikView

Model Qlikview

emteam162 — Mon, 22 Aug 2016 15:55:02 GMT

Hi everybody,

I have two tables that I want to connect each other particularity that the links between these tables are the following fields

id, fk1 and fk2

table1

id	dim1	dim2
1
2
3
4
5
6

table2

fk1	fk2	dim3	dim4
1
2
3
4
5
6

the resultat :

Look enclosed

how i can do that

Many thanks,

Said

Re: Model Qlikview

Gysbert_Wassenaar — Mon, 22 Aug 2016 16:01:25 GMT

rename fk1 to id

Re: Model Qlikview

richard_chilvers — Mon, 22 Aug 2016 16:03:27 GMT

Do you mean that you link table 2 to table 1 by joining fk1 and fk2 together, and matching to id ?

Re: Model Qlikview

emteam162 — Mon, 22 Aug 2016 16:05:44 GMT

yes

fk1=id

and

fk2=id

Re: Model Qlikview

squeakie_pig — Mon, 22 Aug 2016 16:07:14 GMT

This is a useful thread for understanding different ways to 'join' tables. You may not necessarily need a traditional join to get the result you want

Understanding Join, Keep and Concatenate

Re: Model Qlikview

emteam162 — Wed, 24 Aug 2016 13:44:23 GMT

Please, any idea

Re: Model Qlikview

agomes1971 — Wed, 24 Aug 2016 13:48:50 GMT

Hi,

read this

Link Table in QlikView – Learn QlikView

HTH

André Gomes

Re: Model Qlikview

maxgro — Wed, 24 Aug 2016 14:05:00 GMT

it seems you only want to "conect" when

fk1 = id and fk2 = fk1

id fk1 fk2 join?

1 1 1 yes

1 1 2 no

1 2 1 no

1 1 no

is that what you want?