topic No data to display in QlikView

No data to display

Tue, 28 Sep 2010 07:43:34 GMT

Hi,

I have graph dashboard, there are some scenario where I don't have values, so in that graph it is showing "No data to display"

But instead of that message I want to display something like "Trend is below 100".

Pls guide me FYI..I am using 8.2 version.

Thanks,

No data to display

Tue, 28 Sep 2010 07:51:19 GMT

Hi,

For this go to properties of the chart and choose the general tab---->click on Error Messages.. button there give the custom message for that chat with a condition

for ex: if(Sum(sales)>0,'Trend is below 100')

Thanks & regards,

Santhosh G

No data to display

jonathandienst — Tue, 28 Sep 2010 07:55:49 GMT

I there is no way of overriding the "No data to display" message, but if you know what is causing the message (and it seems you do), then this is a workaround:

Create a text box that occupies the same screen position and size for the chart
Change the text box layer that it lies above the chart - if the chart is on the normal layer, set the text box layer to top.
Put whatever message you want your users to see in the text box.
Create a show condition for the text box that displays it when your chart has no data. (This is where you need to know what's causing it, because you will have to write an expression - there is no direct way of checking the chart).

Jonathan

No data to display

Tue, 28 Sep 2010 08:11:59 GMT

Thanks Santhosh for the quick respose, but nothing is displaying I followed as you suggested.

Thanks,

Re: No data to display

gaurav2017 — Wed, 25 Jul 2012 11:10:46 GMT

If I want to display a custom message like "Please atleast select a Month or Year" as the graph in my case shows "No data to display" when there is No Selection

Re: No data to display

cspindley — Wed, 20 Mar 2019 08:52:27 GMT

thanQ