Business Intelligence (BI) is like a compass for companies. It helps them navigate through vast amounts of data to make smart decisions and gain valuable insights. At the start of their business, most companies used Qlik View for many years, but now, Qlik View is the oldest version. That’s why most companies are migrating to Qlik Sense, as it is the latest version of Qlik View and a more modern and user-friendly tool. In this article, I will help you with a step-by-step process of migrating from Qlik View to Qlik Sense.
Migration from QlikView to Qlik Sense can be a complex task, but we can manage it with proper planning and execution. Below is the step-by-step process:
Open your QlikView Desktop, Server, or Enterprise version. In that, open your existing QVW file and understand the total application, data model, and user access that you are migrating. This will help you create the dashboard in Qlik Sense.
Open your front end once, verify your dashboard, and check the label names for your charts.
After understanding the Total application and verifying the front end, try to save it on your PC or Server as a .qvw file.
Ex:
Note: In the above diagram, 1 indicates to enter the File name, 2 indicates save as .qvw File, and 3 indicates after entering both 1 and 2 then click on save.
Once it is saved, open your Qlik Sense Application and login with your credentials. After that, the Qlik Sense Desktop Hub displays.
In Qlik Sense Desktop Hub, on the right side top corner, your profile will be displayed, click on it.
In your profile’s drop-down list, click on Dev Hub.
It will navigate to a new Dev-hub page in your browser. On the Dev Hub page, you will find various tools displayed. Lastly, locate and click on the option labeled Qlik View Converter.
It will navigate to the QlikView Converter web page. Then click on Plus Symbol (⊕) on that page.
The new tab will display to select the QVF file from the local system or from the server. Then, select the file and click on Open.
It will upload into the QlikView Converter Page, and you will get a success message. After that, you can see the uploaded file on the left side of the page and then click on it.
Then it will display a new screen on that page about the Visualization, Dimension, Measures, Variables, and Uncoverted Objects.
Now, click on the Visualization. It will show all the Sheets below that are present in the QVW file. Select the required sheet and click on it. Then select the checkbox for the charts required from that sheet. Also, verify your Visualization.
After verifying the visualization and moving to the dimensions, click on it to verify your dimensions in that QVW file, and select the required dimension from it.
On that page itself, click on the Measures tab, verify your measures from that QVW file, and select the required measures from it.
On that page itself, click on the Variables to confirm and review the variables from that QVW file that are currently available.
Click on the Unconverted Objects tab on that page and check the objects that were not converted. Then, verify the issues associated with those objects. There is no issue present in my QVW file.
After completing all the above steps, click on Create app at the bottom of the right side.
After clicking on the Create app, you will receive a pop-up at the bottom of the page stating, “App created and is available in your Qlik Sense Hub.”
Open up your Qlik Sense Hub. You will find the app added with its name. Click on it to open.
Navigate to the Data Load Editor page. Then, try to change the paths of every table in each section and additionally create a new data connection to link with the tables.
Old Path:
New Path:
After changing all the paths, click on Load Data. It should run successfully without any errors, synthetic keys, or circular loops.
After completing the data loading process and transitioning to the front end, creating visualizations becomes easy. This can be achieved either by dragging and dropping the sheet using the Sheet ID or by accessing the Sheet names located under Assets → Master Items → Visualization → Charts.
After completing the visualization, you can view your measures and dimensions in Assets → Master Items → Measures & Dimensions, which have been migrated from QlikView.
You can also verify your variables in Assets, all of which have been migrated from QlikView.
After creating your dashboard by drag and drop, if you want to edit your chart, you can also do so by clicking on the Edit sheet.
After completing all the editing of the sheet, click on Done Editing.
After completion of the above steps, your Dashboard is ready to use.
Finally! We have learned how to migrate from QlikView to Qlik Sense step by step. Qlik Sense is easier to use and can handle more data. Even though Migration is more difficult, the process itself imparts valuable skills and also teaches you to understand the data. Based on your choice, you can use QlikView or Qlik Sense, but Qlik Sense is an upgraded version and it is also user-friendly.
