topic Re: How to customize the ''No Data to Display'' error message..... in QlikView

How to customize the ''No Data to Display'' error message.....

Fri, 28 Nov 2014 09:01:33 GMT

Hi,

I need to customize ''No data to display'' error message on my bar chart for no data available for current selection.So how can i change this error message ...Please any body help me on this.

Thanks,

Vasudha

Re: How to customize the ''No Data to Display'' error message.....

salto — Fri, 28 Nov 2014 09:07:47 GMT

Hi,

in the General tab of the properties of the bar chart, there is a button in the bottom left named "Error messages" where you can customize the error messages shown in the chart.

Hope this helps!

Re: How to customize the ''No Data to Display'' error message.....

NZFei — Thu, 11 Dec 2014 23:24:50 GMT

Making the change in "Error message" does not change the text for "No data to display".

It is impossible to change "No data to display" according to my know.

Re: How to customize the ''No Data to Display'' error message.....

Mon, 15 Dec 2014 18:16:43 GMT

Fei is right, the message cannot be changed. BUT fortunately you could produce a "calculation condition not fulfilled" condition which error message could be customized. E.g. I add the expression directly in the calculation condition. When it returns null, the condition is not fulfilled and I could make use of the custom error message box.

Re: How to customize the ''No Data to Display'' error message.....

Thu, 02 Jun 2016 09:51:09 GMT

Hi,

You can use a text box with your message to hide your graph when data is null.

Make a copy of bar graph in different sheet and convert that chart type from General tab to Straight Table.

After then you can use macro for this table (say CH16😞

Sub Msg

set cell=ActiveDocument.GetSheetObject("CH16").GetCell(1,4)

ActiveDocument.Variables("v").SetContent cell.text, True

set cell=nothing

End Sub

This will store the total (which is 0 whenever "no data to display" comes) of your expression in variable "v".Then you can use this v variable to show/hide your text box.

Hope this helps

Thanks!

Re: How to customize the ''No Data to Display'' error message.....

NZFei — Thu, 02 Jun 2016 21:19:15 GMT

Will this automatically give the total number to the variable v? It looks to me that we still need to set up a button to run the micro.

Cheers.

Fei

Re: How to customize the ''No Data to Display'' error message.....

Fri, 03 Jun 2016 08:12:10 GMT

Yes, you have to make some button to run macro. But to run this automatically on the basis of user selection , apply triggers (to Run macro) on all columns through which data of that table (CH16) changes.

Note: in my table cell(1,4) contains total. For getting this value , check "Expression total" instead of "No Total" under expression tab

thanks!