Use case for function DoesVisualizationHaveData

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















Info
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 the function LimitText?

      FIRST CREATED ON 19 Jan 20256 I AUTHOR Emma Camacho Sometimes it is necessary to truncate texts to generate nicer-looking tables. The function LimitText will help you with this, available in version 3.6.3 and above. Looking for Additional Guidance? ...

    • How to use the Conditional element in a Table in a Word Report?

      FIRST CREATED ON 3 Feb 2026 I AUTHOR Emma Camacho This feature was introduced in version 3.6.4. It is possible to use a Condition Element to remove rows in a Table in a Word Report. For example, with this Template the Output if the condition is true ...

    • How to use page breaks in Excel when using a repeater (same sheet)? (2/2)

      FIRST CREATED ON 24 Jun 2025 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 use page breaks in Excel when using a repeater (same sheet)? (1/2)

      FIRST CREATED ON 24 Jun 2025 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 use page breaks in Word when using a repeater?

      FIRST CREATED ON 6 Oct 2025 I AUTHOR Emma Camacho This is an example of the use of Page Breaks in Word when using repeaters. The output is a Report that shows all the Sales Reps from a specific Region. It should look like this: The template looks ...