Congratulations!!! your dream came true and you have been hired as a QlikView developer.
Now you need to know things to be successful and to provide value to your client.
a. Get a licensed copy of QlikView desktop.
- Depending on the permissions on your office laptop, you can either download QlikView desktop from Qlik.com or have your infrastructure team install QlikView on your machine.
- To get the license, either you will be provided a license key or more than likely you will lease a license from the QlikView server.
- Learn more about QlikView Licenses.
b. Before developing a dashboard, gather requirements from the user.
- To understand the user requirements, ask questions to understand what users are trying to achieve.
- What information users are trying to get and what kind of visualization/s are required. Gain understanding of the KPI’s (Key Performance Indicators).
- Based on the requirements, gather info on the data sources available. Look for credentials to access the data sources. Verify if all the data elements are present in the data sources provided.
- Create a requirement document working closely with the users. Create dashboard mockups in excel.
c. Create folder structure for development
1. This folder structure will help in organizing your development. This folder structure will typically have the following folders
Includes – to store include files such as db connection,variable declaration etc.
Images – logo or anyother images required in development
Data – Any data files such as QVD files or excel files
Apps – Any QlikView design files (qvws)
c. Create datamodel
- Analyze the underlying datamodel. Explore relationship between the tables. Identify key matching fields to create associations.
- Identify Dimensions and Fact tables.
- Build QVDs (QlikView Data Files). Create multiple layer QVD architecture – Data layer, Transformation layer and Presentation layer.
- Create separate tabs in script editor to organize your script.
- Resolve synthetic keys.
- Identify smaller tables, which can be removed using the Mapping load statements.
- Use Preceding load and resident load to perform data transformations.
- If multiple fact tables are present , use Link table or Concatenate.
- Use incremental load to load updated/new rows from the source data.
d. Building dashboards
- Use Binary load so that data complexities are hidden.
- Use variables for calculations. Use separate text or excel files to store these variables so that they can be reused.
- Create multiple tab dashboard.
- Create visualizations as per the user requirements. Use muted colors so that user focus is on the data.
- Use Set Analysis and Aggr( ) expressions for complex calculations.
- Provide security to your qvws using Section Access.
d. Server Deployment
- Prepare dashboard for deployment. Make sure to test your dashboard data against the source data.
- Place your qvws in the Source Document folder on the server.
- Create tasks to run the data load and refresh your dashboards.
- Learn more about deploying qvws on the server.
QlikView is an amazing application. To learn QlikView data modeling and visualization in an organized step-by-step fashion with exercises explore QlikView Essentials
To get scenario based QlikView questions to prepare for any QlikView technical discussions, explore QlikView Questions and Answers
For affordable QlikView training