Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
chiru_thota
Specialist
Specialist

Is Qlikview Expressor a ETL tool ?

Hi All,

By using Qlikview expressor can we combine more than one QVW data models and create a new report ?

Thanks,

Chiru

3 Replies
advait_thakur
Creator III
Creator III

Hi Chiranjeevi,

  Expressor is a data integration tool with a semantic framework and primary purpose is to manage deployment, data and metadata. It maintains data consistency with all applications and offers a reusable version which is controlled in repository to reduce development time. I am attaching a link for your reference, please have a look on it, I hope this is informative and helpful.

http://community.qlik.com/blogs/qlikviewdesignblog/authors/mto

Regards

Advait

Join the official Qlik Enthusiast's page here
https://www.linkedin.com/groups/6513382/
Not applicable

Hi Chiru,


QlikView Expressor (QVE) provides data governance and data management within a QlikView environment; providing visibility and data confidence in QlikView deployments. It strengths enable the creation of a single conformed data management layer that can be used to drive QlikView applications.


QlikView Expressor has also been used as an ETL (Extract Transform Load) / data integration tool to supplement other data preparation needs such as the creation of various data stores. This is common in a setting where other ETL tools are not available.


QVE can help consolidate multiple data sources, augment data and create a data store/mart/warehouse to be accessed by QlikView and other applications. Other benefits of QlikView Expressor include its ability to graphically prepare and control the flow of data while storing, sharing and reusing various components of the development process.


Thanks,

Varun Bhat

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes, Expressor is an ETL tool.

No, Expressor cannot directly combine multiple qvw data models into a single data model.

The general flow (with or without Expressor) to combine qvw models is:

1. Binary load the qvw.

2. Store each Qlikview table in the model to a QVD.

3. Load those QVDs into a new,merged QVD.

NOte that because of the restriction that a script may contain only one binary statement you can't process the above in a loop over multiple QVWS. You have to build a separate script for each qvw, or alternatively, store the QVDs in the script that builds the model.

Rob