topic Do we have Shortcut joins like solution in Qlikview Reporting tool in QlikView

Do we have Shortcut joins like solution in Qlikview Reporting tool

ankurakash — Tue, 08 Oct 2013 07:48:31 GMT

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

Re: Do we have Shortcut joins in Qlikview Reporting tool

rwunderlich — Tue, 08 Oct 2013 07:54:25 GMT

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

Re: Do we have Shortcut joins in Qlikview Reporting tool

Gysbert_Wassenaar — Tue, 08 Oct 2013 08:12:14 GMT

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.

Re: Do we have Shortcut joins like solution in Qlikview Reporting tool

ankurakash — Tue, 08 Oct 2013 09:13:26 GMT

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