hi @ashishp
If you want to use that query, you should try using JOINS statements instead of all those WHERE conditions. Your database manager will thank you, and the users of that application will be less affected
The advisable thing would be to do the complete extractions of the tables, without filtering or renaming and then build your model using instructions such as concatenate, joins or letting your tables be connected by the fields that have the same names.
if you are not familiar with the use of the script, you can try to use the Data Manager
https://www.youtube.com/watch?v=b2wFIjqV8U8&list=PLkRFvjyuHFvKDnIvwny2qKxKSjn-DkI3k
If you want to have better control on the data, you can try to do it manually in the script
https://www.youtube.com/watch?v=rPK-1xE6VLw&t=179s
In qlik it is always advisable to make an ETL layered model, where in a first app you do the extraction and save QVD files.
In another app you do the transformation renaming fields, concatenating and/or joinings tables and saving QVDs already prepared to be consumed.
and finally you make an app that does not contain any logic and only loads the second layer of QVDs
Hope this helps.
Best,
help users find answers! Don't forget to mark a solution that worked for you & to smash the like button! 🙂
