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

Sun, 04 Oct 2015 21:08:35 GMT

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.

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

qlikviewwizard — Sun, 04 Oct 2015 23:45:16 GMT

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

topic Re: How to show 'No data available' message whenever there is no data available in QlikView

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

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