Multiple joins in qlikview

Tue, 09 Jun 2015 04:34:31 GMT

hi good day, i am very new to business intelligence such as qlikview. right now i doing a script that needs to join multiple tables, something like this:

i know to construct it in SQL but not in qlikview so my question is?

1. how can i join this tables in the script?is it possible?

can someone teach me how, or atleast show some sample codes., anything will help thanks you very much

Re: Multiple joins in qlikview

maxgro — Tue, 09 Jun 2015 20:28:21 GMT

yes it possible

I suggest to read this

To Join or not to Join

then if you still want to join all the tables:

VIOROF:

sql select * from VIOROF;

// sql select .... if you read the data from a database

inner join (VIOROF)

sql select * from VICNCN;

// you can see there is no where, the qlikview join is made using fields with the same name

// if the join fields are different, rename

inner join (VIOROF)

sql select * from VICDCOND;

// this is the 2nd join in your table

inner join (VIOROF)

..........

you can find a lot of help about join (and load)

- in QlikView online help

- Preceding Load

- LOAD data into QlikView

topic Re: Multiple joins in qlikview in QlikView

Multiple joins in qlikview

Re: Multiple joins in qlikview