Report Introduction
How to add the user name to a Report when requested by M&D Hub
FIRST CREATED ON 19 Aug 2025 I AUTHOR Emma Camacho Add a parameter with the following Hub Input Field options Type: Drop-Down Field Source: User Name Add an Expression Element and insert the previously created parameter, you can then add it to the ...
How to create a Word report using PowerBI as a data source in Mail & Deploy (with example)?
FIRST CREATED ON 11 Aug 2025 I AUTHOR Emma Camacho Creating an Word report using a PowerBI as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started: Use case Design a ...
How to create an Excel report using PowerBI as a data source in Mail & Deploy (with example)?
FIRST CREATED ON 12 Aug 2025 I AUTHOR Emma Camacho Creating an Excel report using a PowerBI as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started: Use case Design the 3 ...
How to use page breaks in Excel when using a repeater (same sheet)? (1/2)
FIRST CREATED ON 24 Jun 2026 I AUTHOR Emma Camacho This is an example of the use of Page Breaks in Excel when using repeaters. The output should look like this: Each page will have 4 tables and the last one might have less. The template looks like ...
How to add symbols to negative and positive numbers?
FIRST CREATED ON 17 Jun 2025 I AUTHOR Emma Camacho To add symbols to the numeric cells (negative and positive numbers): Use the following expression in Qlik for the column f3 with symbols: Expression: num(f3, CHR(9650) & '#,###' & ';' & CHR(9660) & ...
How to use page breaks in Excel when using a repeater (same sheet)? (2/2)
FIRST CREATED ON 24 Jun 2026 I AUTHOR Emma Camacho This is an example of the use of Page Breaks in Excel when using repeaters, this time the Debug version of the report. The definitions are the same as the example in How to use page breaks in Excel ...
How to format using Cell Settings cells that are null?
FIRST CREATED ON 17 Jun 2025 I AUTHOR Emma Camacho To format the cells that are null in the following example: Use Cell Settings to format the cells: Pattern Expression: if (String.IsNullOrEmpty([CellValue]),1,[KeepOriginal] ) Color Expression: if ...
Use case for function DoesVisualizationHaveData
FIRST CREATED ON 29 Apr 2025 I AUTHOR Emma Camacho The following App has a Pie Chart and a Table. Depending on the Qlik Sense property Include null values, the Pie Chart and Table will look different. Using the function DoesVisualizationHaveData in ...
How to export numbers formatted as percentage in a CSV report ?
FIRST CREATED ON 25 April 2025 I AUTHOR Emma Camacho If the App has a table with the following number format the output of a CSV Report looks like this Edit the column's expression as follows to get the correct format text(num( measure1 / measure2,' ...
How to use Mail & Deploy tags in HTML reports with the img src=
FIRST CREATED ON 24 Apr 2025 I AUTHOR Emma Camacho Another way to add images in a HTML Report is using the HTML code img scr=. <img width="xxx" height="yyy" src="%%your_image_tag%%"> The following HTML codes are mandatory width, height and src. ...
Handling Date Variables in Mail & Deploy Reports
You have a date variable in Qlik (formatted as DDMMYYYY), but when used in Mail & Deploy, it gets converted into a number. For example, the file output appears as File_45014.xlsx instead of File_29032023.xlsx. Solution: To resolve this issue, you can ...
How to show/hide sheets in Microsoft Excel reports conditionally?
FIRST CREATED ON 19 Dec 2024 I AUTHOR Emma Camacho It is possible to show/hide sheets in Microsoft Excel reports using the Condition property of Elements together with the Exception Behavior. Follow the example to hide Sheets if the CY Sales = 0 and ...
How to sort the Templates when using more than one in a Report
FIRST CREATED ON 4 November 2024 I AUTHOR Emma Camacho This recommendations applies to: * The Report has more than one template * The definition of the which templates to use to create the Report is stored in a field * A specific sorting order is ...
How to create an Excel report using Snowflake as a data source in Mail & Deploy (with example)?
FIRST CREATED ON 5 Mar 2024 I AUTHOR Emma Camacho Creating an Excel report using Snowflake as a data source in Mail & Deploy allows you to leverage powerful data analysis capabilities. Here's an example to help you get started: Use case: Display ...
How to synchronize cell insertion in an Excel report in Mail & Deploy (with example)?
FIRST CREATED ON 31 Jan 2024 I AUTHOR Emma Camacho Synchronizing cell insertion in an Excel report within Mail & Deploy ensures that your data is accurately aligned and formatted. Here's an example to guide you through the process: If you need a ...
How to activate Qlik Sense Themes in Mail & Deploy?
FIRST CREATED ON 14 Jun 2023 I AUTHOR Emma Camacho Qlik Sense themes offer a powerful way to customize the appearance of your reports. By applying themes, you can easily align the look and feel of your reports with your brand or preferred style. ...
How to set Culture to a Report?
FIRST CREATED ON 23 May 2023 I AUTHOR Emma Camacho Configuring the culture for a report ensures correct date formats, currency, and locale-specific settings. This article shows you how to set it up: (1) Set the Culture in the General Report Settings ...
What is Report Culture Awareness, and how does it impact Mail & Deploy reports?
FIRST CREATED ON 30 Apr 2020 I AUTHOR Emma Camacho A culture is a set of rules that specify how numbers and dates are formatted (Windows Regional Settings). Generally speaking, the culture defines in what format numbers and dates are being presented ...