Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

Multiple joins in qlikview

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:

joins.png

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

1 Reply
MVP
MVP

Re: Multiple joins in qlikview

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