Example: Manually recreating QlikView content in Qlik Sense

Certain visualizations and other objects cannot be converted using the QlikView converter. This topic provides an example of how to manually recreate some of that content in Qlik Sense.

In this example, we do the following to recreate the QlikView document Customers.qvw in Qlik Sense.

1. Convert some objects in a QlikView document called Customers.qvw using the QlikView converter.
2. Place those QlikView objects in a Qlik Sense app.
3. Manually recreate the QlikView objects that were not converted in the Qlik Sense app.

Customers contains four sheets:

• Main
• Container object
• Conditional show
• Forecast

The document contains the following objects that the converter will convert, or that we will recreate recreated manually in Qlik Sense:

• Main sheet:
  • list boxes (converter)
• Container object sheet:
  • visualizations (converter)
  • container (manual)
• Conditional show sheet:
  • list boxes (converter)
  • table box that uses the conditional show function (manual)
  • text objects (manual)
• Forecast sheet:
  • chart (converter)
  • slider box with variable for user input (manual)

Requirements

• Access to the Dev Hub in Qlik Sense Enterprise on Windows.

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.

Recreating a QlikView document as 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 Customers.qvw document into the converter. Qlik Sense processes the document.

3. Select the Customers.qvw document, and then Select all objects in the Visualizations tab.

   Visualizations tab in Customers document in converter tool

   

4. Review the tabs and then click Create app. The Customers app is created in the Qlik Sense hub. The objects are created as Master items in the Assets panel. You can access and create new variables in the Variables window.

   Assets panel in Qlik Sense
   
5. Open the Customers app and create a new sheet. Name the sheet Main. Click Master items and then drag the following tables onto the sheet:
   • Country
   • City
   • Customer
   • ProductName
   Completed Main sheet in Customers app

   

   Information noteFor more detailed steps about creating a Qlik Sense app using the QlikView converter, see Example: Moving QlikView content to Qlik Sense using the QlikView converter
6. Create a new sheet and name it Container object.
7. Recreate the behavior from the container in QlikView.

   1. Click Edit sheet on the sheet, and then click Charts. The Container object is listed.

      Container in Charts

      

   2. Drag Container onto the sheet.

      Container on sheet

      

   3. From Master items, add Sales by Country, Top 20 customers and # of orders, and Sales By Category to the container. When we are done editing, we can view each of the charts by clicking on their respective tabs.

      Completed Container object sheet

      

8. Create a new sheet and name it Conditional show.
9. Recreate the behavior from the table box in QlikView. The table displays when the conditional show function evaluates to true.
   1. From Master items, drag the Customer, OrderDate and OrderID tables onto the sheet.
   2. From Charts, drag a new table onto the sheet, and then name it Conditional table.

   3. Add ProductName to the table as a dimension. Add Quantity, Unit Price, and Price to the table as measures.

      Conditional show sheet

      

   4. Click the Conditional table, click Add-ons in the Properties panel, and then click Data handling.

   5. Enter the following for Calculation condition: Count (distinct OrderID)=1

      This is the same expression that was used for the show condition in QlikView.

   6. Enter Select one value in the OrderID table for Displayed message.

      Modify Conditional table

      

      When we are done editing, we can select a value in the OrderID table to show the associated data in the Conditional table.

      Select one value for Order ID

      

      Associated data in Conditional table

      

10. From Charts, drag Text & image onto the sheet.

    Text & image in Charts

    

11. Add the following text: Select one single order for the details to be shown

12. From Charts, drag KPI onto the sheet.

    KPI in Charts

    

13. Under Data in the Properties panel, enter =Sum(Price) as the Expression for the measure, and Total value of order for the Label.

    Configure KPI

    

    Additionally, set Calculation condition and Displayed message to the same values as those for the Conditional table.

    When we are done editing, we can select a value in the OrderID table to show the associated data in the Conditional table and the KPI.

    Select one value for Order ID

    

    Completed Conditional show sheet

    

14. Create a new sheet and call it Forecast.
15. Recreate the Next year forecast table from QlikView.

    1. From Visualizations in Master items, drag Next year forecast onto the sheet.

       Next year forecast visualization

       

    2. Click the visualization, and then Edit the linked master item.

       Edit master item

       

    3. Under Appearance/Presentation in the Properties panel, change the view from Stacked to Grouped. Under Colors and legend, set Show legend to Auto.

       Chart presentation

       

       When we are done editing, the appearance of the visualization is similar to that from QlikView.

       Completed Next year forecast visualization

       

16. Recreate the slider box from QlikView on the Forecast sheet. The slider uses a variable for user input. The variable was copied by the converter.

    1. From Qlik Dashboard bundle in Custom objects, drag Variable input onto the sheet.S

       Variable input in Custom objects

       

    2. Under Appearance/General in the Properties panel, enter Change next year in % for the Title.

    3. Under Variable, select the Forecast variable under Name, and then select Slider under Show as.

    4. Under Values, set Min to -10, Max to 25, and Step to 5. Finally, select Slider label.

       Configure Variable input

       

       When we are done editing, we can use the slider to change the forecast.

       Completed Forecast sheet