How to show 'No data available' message whenever there is no data available

[#1]

Hi

I have a request like this:

by default the chart or tablebox will show the content.

if due to the user selection, there is no data returned,

instead of leave the object blank, user would like to see a message text label, showing 'No data available'.

I saw it is achievable in one qvw, but I cannot find where did it set?

Please let me know. Thanks.

[qlikviewwizard]

Hi use the macro as mentioned below:

No data available isn't a error - it meant there isn't any data in your object for your certain selection. Therefore you need another approach. A very simply way is to count/sum the main-calculation from your object in a variable and if the result is greater then 0 then there are data available.

var CheckData = if(sum(VALUE) > 0, true(), false())

If ActiveDocument.Variables("CheckData").GetContent.String = true Then

    'your Export

else

     'nothing

End If

Marcus Sommer's answer at Re: Macro to check for "No data available" Error