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 the condition property of both Elements, different Reports will be generated. Below are the combinations of including/excluding the null values in Qlik and including/excluding the null values in the function DoesVisualizationHaveData.

Include null values Property in Qlik Sense	Chart and Table according to the property Include null values	Both M&D elements have the Condition property set to DoesVisualizationHaveData(0) and a Replacement Text "no data" in the Exclusion Settings.	Both M&D elements have the Condition property set to DoesVisualizationHaveData(-1) and a Replacement Text "no data" in the Exclusion Settings
		M&D output	M&D output

Looking for Additional Guidance?

If you require more detailed information or further assistance, please visit our comprehensive Online Documentation. Our resources are designed to help you navigate all features and functionalities effectively.

• Related Articles

• 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. ...

• How to Cycle Through a Chart with a Variable as a Dimension in a Mail & Deploy PowerPoint Report?

  You wish to cycle through a chart in a Mail & Deploy PowerPoint report where the dimension is defined by a variable. Manually assigning values to the variable on each slide did not work as expected. Solution: Instead of manually assigning values, you ...

• 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 ...

• 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 ...

• 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 ...