Skip to main content Skip to complementary content

Using smart sheets in Insight Advisor for period-based analyses

Use smart sheets in Insight Advisor to automatically build full sheets for your Qlik Sense app. Smart sheets are specifically designed for building period-based analyses.

Smart sheet automatically generated by Insight Advisor

Smart sheet automatically built by Insight Advisor using the Period changes (detailed) analysis type

Access the smart sheet builder from Insight Advisor Analysis Types when you select any of the following analysis types:

  • Period over period (selected)

  • Period changes

  • Period changes (detailed)

Information noteThe Period over period analysis type is a similar analysis type, but technically only builds single visualizations. It is mentioned here because the requirements for working with this analysis type are the same as for the smart sheet-based analysis types.

Requirements

The following table outlines what you need to be able to use the Period over period, Period over period (selected), Period changes, or Period changes (detailed) analysis types.

Requirements for working with period-based analysis types in Insight Advisor
Analysis type Requirements
Period over period At least one calendar period defined using autocalendar.
Period over period (selected) At least one calendar period defined using autocalendar.
Period changes

One of the following:

  • At least one calendar period defined using autocalendar.

  • At least one calendar period defined using a custom calendar.

Period changes (detailed)

One of the following:

  • At least one calendar period defined using autocalendar.

  • At least one calendar period defined using a custom calendar.

 

Using calendar periods and autocalendar

Using autocalendar in your app is the easiest way to guarantee you will be able to use all period-based analysis types. This is because autocalendar automatically adds a number of calendar periods into the app to make period-based analyses easier.

When you build an app and load data with Data manager, autocalendar is automatically created in the script if date fields are detected in the data.

If you are not able to use these analysis types in your app, it is because you have not created the required calendar period. This could be due to a number of reasons, including:

  • Your app was built using scripting, and you did not manually insert the autocalendar script into the load script.

  • You do have autocalendar in the app, but all calendar periods were removed in the app's business logic.

  • Your app has at least one calendar period, but it was created using a custom calendar (with custom calendars, the Period over period and Period over period (selected) analysis types are not available).

Adding autocalendar to your load script

If you have built your app in Data load editor and have not defined a custom calendar, you can insert the autocalendar script directly into the app's load script and change the names of the fields you wish to link to autocalendar.

See Automatically deriving date fields using autocalendar for the script code and other details.

Adding or re-adding calendar periods

If calendar periods have been deleted from your app's business logic, add at least one of them back to access the available period-based analysis types. For autocalendar-defined calendar periods, these can be either Last sorted value or Relative.

For further instructions on creating calendar periods based on autocalendar or a custom calendar, see Creating calendar periods.

Creating smart sheets

For a full example of how to create a smart sheet and add it to a sheet in a Qlik Sense app, see Building an app. Look for the section Create a sheet from analysis types.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!