Skip to main content
Announcements
See why Qlik is a Leader in the 2024 Gartner® Magic Quadrant™ for Analytics & BI Platforms. Download Now
cancel
Showing results for 
Search instead for 
Did you mean: 
ashishp
Creator
Creator

Build Data Model from Query

Hi There 

I have one query which is taking lot of time to run. 

Want to convert this query into Qlik Sense Data model. 

any suggestions? 

Thanks in advance.  

 

 

Labels (2)
1 Reply
RafaelBarrios
Partner - Specialist
Partner - Specialist

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! 🙂