Skip to main content Skip to complementary content

Qlik Reporting Service specifications and limitations

This help topic lists the capacities and limitations that apply to reporting in Qlik Cloud Analytics, both in the user interface and via the Qlik Reporting Service API. It specifically notes limitations that apply to using the value-add subscription options available with the Qlik Reporting Service.

The Qlik Reporting Service is a value-add set of services within a Qlik Cloud subscription that provides enterprise-level reporting capabilities from Qlik Cloud. With the Qlik Reporting Service, the following capabilities are available:

  • Tabular reporting

  • Reporting with Qlik Application Automation

  • Direct usage of the Qlik Reporting Service API. See: Reports

For more information about reporting in Qlik Cloud Analytics, see Reporting from Qlik Cloud Analytics.

This page lists limitations for the value-add capabilities noted above. The following information is provided:

  • Qlik Reporting Service consumption limitations

  • Limitations and specifications for each of the value-add capabilities within the Qlik Reporting Service

The information on this page does not necessarily apply to other reporting capabilities in Qlik Cloud (for example, subscription reports). For limitations specific to those capabilities, refer to their associated help topics.

Consumption limitations for Qlik Reporting Service value-add capabilities

The following consumption-related limitations apply to all Qlik Cloud licenses, unless otherwise stated. The capacities listed on this page are a metered combination representing the combined usage across each of the included Qlik Reporting Service capabilities in the subscription.

For the consumption limits and capacities specific to your Qlik Cloud subscription, check with your service account owner and refer to the terms of service for the Qlik Cloud subscription you are using.

  • Across all forms of reporting (including capabilities outside the Qlik Reporting Service), a tenant can make a maximum of 30,000 reporting-related requests per day. The requests made by Qlik Reporting Service value-add capabilities count toward this limit.

  • Maximum number of reports per month: Varies depending on your Qlik Cloud license.

    If you need additional reports, contact your tenant admin.

For detailed information about your license metrics, see Product Description for Qlik Cloud® Subscriptions. Administrators can view license information and monitor the number of generated reports and automation runs in the Management Console. For more information, see Monitoring resource consumption.

More detailed information about your personal automations is available through My Automations in the hub. Tenant admins can view consumption metrics on the Home tab of the Management Console.

Limitations for tabular reporting

General limitations

These limitations apply to both the Qlik add-in for Microsoft Excel and the tabular reporting functionality in Qlik Sense:

  • Tabular reporting is not available in Qlik Cloud Government.

  • When using a custom font in your app, it is assumed you have the required license to use that font in output from Qlik Sense. To ensure your fonts are licensed, make use of the multiple open-source fonts available in Qlik Sense for styling app content.

    If you have the required licenses for a font that is not available in the default Qlik Sense themes, Create themes with custom fonts to learn about adding the font to a custom theme.

  • When characters that are unsupported in the selected font are used in app content, these characters will be rendered in output with a font in which they are supported. Different behavior might be noticed if a custom font is used.

  • If you use a custom theme in your app to define font use (for example, adding a font file directly to the theme), fonts rendered in various outputs might not be the same fonts you have used in your app.

  • Shadows applied to chart objects in the app are not shown in the generated report.

  • Macros and scripting are not supported in Microsoft Excel report templates.

  • Third-party extensions are not supported.

  • Reporting capabilities, including the Qlik Reporting Service value-add features and subscription reports, are not supported in Direct Query apps.

Technical limitations

The following limitations apply to sharing visualizations, with respect to tabular reporting. If these limits are exceeded, your report will fail. If this issue occurs, contact a user with Can edit permission in the app.

The specific limitations are listed below:

  • Maximum image size: 4,000 x 4,000 pixels

  • Minimum image size: 5 x 5 pixels for charts and 20 x 20 pixels for sheets

Limits and limitations for Qlik add-in for Microsoft Excel

Limits

The following table lists limits specific to the Qlik add-in for Microsoft Excel.

Reporting limits for the Qlik add-in for Microsoft Excel
Metric Value
Maximum number of nested levels in a template 3
Maximum number of object tags in a template 200

Maximum number of objects per generated report

  • A single chart, variable value, level value, or expression value counts as one object.

  • For Excel tables, 500 generated cells count as one object. If there is an additional remainder of less than 500 cells (for example, several smaller tables containing a total of as many as 499 cells), this does not count as an object.

50,000
Maximum number of generated images in a report 1,000

Limitations

The following limitations apply to the add-in:

  • The add-in is not supported for use in Microsoft 365 desktop versions of Excel for macOS.

  • It is not possible to use the add-in to connect to a Qlik Sense app located in a managed space. Tabular reporting is not available in managed spaces.

  • The following objects are not supported in report templates:

    • Filter panes

    • Maps

    • Charts with these hypercubes types: Tree, Pivot, or Stacked

  • Using a calculated dimension as a level is not supported. Specifically, the following use cases are not supported:

    • Adding a calculated dimension as a master item, adding this master item to a chart, and then using the chart as a level.

    • Adding a calculated dimension expression to a chart, and then using the chart as a level.

    You can, however, include tabular data consisting of calculated dimension columns inside a level.

  • When using master dimensions inside a level, you can only use master dimensions with the Single type. Drill-down master dimensions are not supported inside levels.

  • Microsoft Excel imposes certain constraints on what is contained within an Excel workbook file. These limitations apply to both Excel report templates and the output they generate. This includes the maximum number of rows, columns, and characters in a single .xlsx file. Refer to the official Microsoft documentation to learn about these external limits.

Limits and limitations for Qlik Cloud Analytics tabular reporting

  • Tabular reporting is not available in managed spaces.

  • A report task has a recipient limit at run-time of 100 users.

  • External email clients often enforce size limits for email attachments. Check with your SMTP provider to find out what your limit is.

    Reports delivered to cloud storage connectors have no file size limit.

  • Report filters are not compatible with Star statements. If an app contains this statement in the script, reports with filters might show unexpected results.

  • When configuring a report filter using the Search selection method, certain search methods are not supported. For more information, see Report filter limitations.

  • If an app contains one or more fields configured with the Always one selected value property, it is required that at least a value for these fields is configured in a filter and applied to the report. If a filter doesn't contain a value for these fields, or no filters are associated at all to the task, the report will fail. The report will also fail when more than one value is applied for fields with Always one selected value configured.

  • You can add a maximum of 1000 recipients and 1000 groups to the distribution list of an app.

Limitations for reporting with Qlik Application Automation

Technical limitations

The following limitations apply to reporting with Qlik Application Automation. If these limits are exceeded, your report will fail. If this issue occurs, contact a user with Can edit permission in the app.

The specific limitations are listed below:

  • Maximum number of fields in the selections: 125

  • Maximum number of field values in the selections: 150,000 total field values across one or many fields

  • Maximum number of alternate states: 125

    Using alternate states for comparative analysis

  • Maximum number of patches: 100

    Patches are properties or styling applied in the app. For example: Adding a sort to a table column.

  • Maximum number of variables: 1,100

    Using variables in expressions

  • Maximum image size: 4,000 x 4,000 pixels

  • Minimum image size: 5 x 5 pixels for charts and 20 x 20 pixels for sheets

  • Maximum number of pages in a report: 200

Other specifications and limitations

  • If you create PDF or PowerPoint reports, the resolution will be 300 DPI.

  • External email clients often enforce size limits for email attachments. Check with your SMTP provider to find out what your limit is.

    Reports delivered to cloud storage connectors have no file size limit.

  • Portrait layout is not supported for sheets that will be outputted to automations in PowerPoint format. Sheets set to portrait layout will be converted to landscape. However, you can use portrait layout if you are using the Qlik Reporting Service API. For more information about using the API to create reports, see the Developer Portal documentation.

  • When using a custom font in your app, it is assumed you have the required license to use that font in output from Qlik Sense. To ensure your fonts are licensed, make use of the multiple open-source fonts available in Qlik Sense for styling app content.

    If you have the required licenses for a font that is not available in the default Qlik Sense themes, Create themes with custom fonts to learn about adding the font to a custom theme.

  • When characters that are unsupported in the selected font are used in app content, these characters will be rendered in output with a font in which they are supported. Different behavior might be noticed if a custom font is used.

  • If you use a custom theme in your app to define font use (for example, adding a font file directly to the theme), fonts rendered in various outputs might not be the same fonts you have used in your app.

  • Shadows applied to chart objects in the app are not shown in the generated report.

  • Third-party extensions are not supported.

  • Reporting capabilities, including the Qlik Reporting Service value-add features and subscription reports, are not supported in Direct Query apps.

More detailed information about your personal automations is available through My Automations in the hub. Tenant admins can view consumption metrics on the Home tab of the Management Console.

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!