Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

datanibbler
Esteemed Contributor

Replace the error_message for "no data"

Hi,

in one of my charts - possibly in others lateron - I'd like to display the standard_error_message "no data" with a custom message. The background is that I have a standard selection for that sheet:

>>> current_year, current_month <<<

<=> In that list, there is no data for the current month, so I get this message. One has to remove the month_selection to get it working.

Can someone help me there? I know that on the "general" tab of the properties_dialog you can set the error_messages, but that particular one is not there.

Thanks a lot!

Best regards,

DataNibbler

Tags (1)
7 Replies
bbi_mba_76
Valued Contributor

Re: Replace the error_message for "no data"

Hi,

maybe there is a better solution, but you could use the calculation condition/show conditional to hide the chart and add a text box with your custom message.

datanibbler
Esteemed Contributor

Re: Replace the error_message for "no data"

Excellent idea, BBI_MBA_76,

there's just one issue: A textbox with the corresp. show_condition will then show up on every tab of that combobox, not only on the one where I have that "no data" issue.

I tried alternatively to use a free_text_box inside that diagram, but it seems that is not displayed when the diagram itself isn't displayed...

Re: Replace the error_message for "no data"

Nibbler

On the General tab of your Chart have you investigated the Error Messages button, when clicked it allows one to to set Custom Messages.

Best Regards,     Bill

datanibbler
Esteemed Contributor

Re: Replace the error_message for "no data"

Hi Bill,

yes, I have tried that.

However, you can set a nr. of messages there - but not that "no data to display"_message.

I think I'll try to tackle that in a different way, though, by simply manipulating the base file so that it has the value 0 in those months where there is no data yet - so I won't get that message to begin with.

I'll be back to debrief if it worked that way.

Excel, here I come...

Best regards,

DataNibbler

datanibbler
Esteemed Contributor

Re: Replace the error_message for "no data"

That worked fine. Now my standard_selections work for that diagram, too - albeit there's nothing to see, there are 0 whatchamacallits in the list for the current month - but at least there is no error message.

That issue is thus solved.

Best regards,

DataNibbler

thornofcrowns
Valued Contributor II

Re: Replace the error_message for "no data"

What Bill is saying is that you can put your own wording into that custom message field and set a Calculation Condition to trigger it, so you don't need to mess about with the data.

Example:

Calculation Condition  =sum(if(IndicatorID='3',Data))>0 will show the custom message ( 'No Waits over 3 hours' )

datanibbler
Esteemed Contributor

Re: Replace the error_message for "no data"

Thanks James,

I understand quite well, I've seen that option and tried it out. The message of "no data to display" isn't there. I could do it otherwise, of course: I could set a condition for the formulas depending on the month_selection and then edit the message of "all formulas deactivated". Several roads lead to Rome...

Best regards,

DataNibbler

Community Browser