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

    • How to use the Filter Dynamic Datasource Fields Action (with example)?

      FIRST CREATED ON 16 Jan 2026 I AUTHOR Emma Camacho This action allows you to be even more flexible. You can build a Supporting App that will contain the name of the fields and their corresponding value. Kind reminder: usually the Supporting App ...