Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I am having multiple QVDs and to create a better data model I need to join most of the tables.
Just need your help, will multiple joins impact the performance of QVS??
Regards,
Balraj Ahlawat
Mapping tables should help.
http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/18/one-favorite-function-applymap
If required then use joins .
Use keys too for auto association.
Refer this doc
I would question why you should join in the first place. Read more here: http://community.qlik.com/blogs/qlikviewdesignblog/2012/09/12/to-join-or-not-to-join
On performance: The join itself can take time and it might be a good idea to make the join in the DB before you create the QVDs.
HIC