Skip to main content

Example: Moving QlikView content to Qlik Sense using the QlikView converter

ON THIS PAGE

RELATED LEARNING

Example: Moving QlikView content to Qlik Sense using the QlikView converter

This topic provides an example of converting a document in QlikView to an app in Qlik Sense Enterprise on Windows.

We do the following in the example:

  1. Convert objects in a QlikView document called Sales.qvw using the QlikView converter.
  2. Place the objects in a Qlik Sense app.
  3. Make our data source available in Qlik Sense.
  4. Modify the load script in Qlik Sense to connect to the data source.

The document contains two sheets called Geography and Sales_Country.

Geography sheet in QlikView

Geography sheet in QlikView

Sales_Country sheet in QlikView

Sales_Country sheet in QlikView

The document contains the following objects that will be converted:

  • Charts
  • List boxes. These are loaded as filter panes in Qlik Sense.
  • Table box
  • Data model
  • Load script. Directory path will be changed in Qlik Sense. Also, data files will uploaded Qlik Sense so that they can be loaded with the script.

The Search box, and the Clear selections and Export buttons, will not be converted. This functionality is built into Qlik Sense.

For more examples of recreating QlikView behavior in Qlik Sense, see Example: Manually recreating QlikView content in Qlik Sense.

Requirements

  • Access to the Dev Hub in Qlik Sense Enterprise on Windows.
  • Permission to upload data files to the Qlik Sense server. This is required for the data load part of the example only.

Restrictions

  • You cannot use the QlikView converter to convert documents that are larger than 500 MB on disk. You can reduce the amount of data in a document, or save the document without data, to reduce the size of a document without losing assets.

Convert a basic QlikView document to a Qlik Sense app

We do the following in this example:

  1. Open the Dev Hub in Qlik Sense, and then select QlikView converter.

    For more information, see QlikView converter.

  2. Drag and drop the Sales.qvw document into the converter. Qlik Sense processes the document.
  3. Select the Sales document, and then select all objects for the Geography sheet (SH02) in the Visualizations tab. Also, select all objects for Sales_Country (SH04) sheet, with the exception of the Country filter pane. This table is repeated in the converter because it appears on both sheets.

    The objects will be created as master items in Qlik Sense.You can delete master items that are not required in Qlik Sense later.

    Visualizations tab in Sales document in converter tool

    Visualizations tab in Sales document in converter tool.

  4. Review the other tabs for objects that will be converted. If there are any dimensions or measures with duplicate names, you can rename them now to avoid confusion in Qlik Sense.

    Dimensions tab in Sales document in converter tool

    Dimensions tab in Sales document in converter tool.

  5. Click Create app. The Sales app is created in the Qlik Sense hub.

    Sales app in Qlik Sense.

    Sales app in Qlik Sense.

  6. Open the Sales app and create a new sheet. Name the sheet Geography.
  7. Open the sheet, click Edit sheet, and then click Master items. The converted dimensions, measures, and visualizations are listed in their respective tabs.

    Converted dimensions, measures, and visualizations

    Converted dimensions, measures, and visualizations.

  8. Click an object to view more information. The tag converter-auto-created indicates that the object was created by the converter.

    Information about Population visualization

    More information about Population visualization.

  9. Drag the following master visualizations onto the sheet:

    • Country
    • Currency
    • Population(mio)
    • Area(km.sq)
    • Table box
    • Population
    Geography sheet with converted objects

    Drag objects onto sheet.

  10. Adjust the sorting on the Population chart.
    1. Click the Population chart, and choose to edit the master item.

      Drag objects onto sheet.

      The Edit master visualization window opens.

    2. In the Properties panel, click Sorting, and then move Population above Country. This re-sorts the data so that the chart matches that from the original QlikView document.

      Edit master visualization

      Edit master visualization.

    3. Click Done. The Edit master visualization window closes and the visualization is updated on the sheet. The Geography sheet is complete.

      Completed Geography sheet

      Completed Geographysheet.

      If you make a selection on the sheet, you can clear it in the Selections toolbar. This replaces the Clear selections box in QlikView.

      Selection in Geography sheet

      Selection in Geography sheet.

  11. Recreate the Sales_Country sheet by dragging the visualizations from the Master items onto the sheet.

    Sales_Country sheet

    Sales_Country sheet.

  12. You can open the global search at any time by pressing Control + F on your keyboard. This replaces the Search box in QlikView

    Global search

    Global search.

  13. To download data, you can right-click an object, click Download as..., and then click Data.

    Download data

    Download data.

  14. Upload the data files to a folder called Data Sources on the Qlik Sense server. This allows us to connect to the files with the data load script.
  15. We then create a connection from the Sales app.
    1. Open the Data load editor from the Prepare tab in the top toolbar.
    2. Click Create new connection, and then select Folder in the window that opens.
    3. Navigate to the Data Sources folder, and then select it. Name the connection and then click Create.

      Create new connection

      Create new connection window.

      The connection is created and added to Data connections.

      Data connections

      Data connections.

  16. Next we change directory path in our load script in the Data load editor so that it refers to our data connection. The path needs to be changed because the script that was imported from QlikView contains the path to a local directory in QlikView.

    Data load script referring to local directory

    Data load script referring to local directory.

    In the above example, we change:

    FROM [Data Sources\Country1.csv]

    to:

    FROM [lib://Data Sources (<user_id>)/Country1.csv]

    where your <user_id> is required to make the connection.

    We then make the change for all Load statements in the script.

  17. We can now load the data by clicking Load data. A progress window indicates that our data has been loaded.

    Data load progress

    Population as alternative measure.