Do we have Shortcut joins like solution in Qlikview Reporting tool

[ankurakash]

Hi,

Would appreciate your response for my query.

Do we have 'shortcut joins' like similar functions in Qlikview as we have in Business Objects?

Or a solution for scenario: We have seven tables each connected in the sequence.

Table A -> connected to table "B" -> Connected to "C"-> "D" -> "E" -> "F" -> "G".

The requirement is I want data from table "A" and table "G" in my report.

There is a solution "shortcut join" to this problem in "Business Objects". Would be helpful if I can know its solution in Qlikview.

Best Regards,

Ankur Akash

[rwunderlich]

IIf you load all seven tables in the Qlikview script, the tables are automatically joined on like field names. Your charts may contain data from table A and table G and the data will be properly linked.

-Rob

[Gysbert_Wassenaar]

No, all tables acts as if they are one big virtual table. There's no need for shortcut joins. Selecting a value in one field will activate all related records in all the other tables. Simply use the fields from table A and G in your report. Any selection in a field from table A will filter the records in table G.

[ankurakash]

Thanks for responding. In case of the above sample scenario, won't it be a performance issue if we have multiple tables with million records between Table A and Table G. Do we have an option similar or like "shortcut joins in Business Objects" where I can skip the intermediary tables and directly connect the requisite tables?

- Ankur Akash