topic Change error text...No numeric values on x axis in QlikView

Change error text...No numeric values on x axis

Mon, 27 Apr 2015 01:18:10 GMT

Hi, when making a selection the chart defaults to a warning of No numeric values on x axis. I would like to change this to something more accurate like No budget available but when I go to Properties->Error Messages and change Default it doesn't change this error message.

Any ideas?

Re: Change error text...No numeric values on x axis

danieloberbilli — Mon, 27 Apr 2015 01:38:03 GMT

I think this kind of error needs to be solved in the expression itself. Could you please post your chart expression?

Re: Change error text...No numeric values on x axis

Mon, 27 Apr 2015 01:41:28 GMT

Hi there, quick reply

=IF(ISNULL(SUM(Budget)),0,SUM(Budget))

The ISNULL is intended to ensure the graph keeps displaying if there is no data and intent was then to display a warning to the user through the error message functionality.

Re: Change error text...No numeric values on x axis

danieloberbilli — Mon, 27 Apr 2015 03:05:34 GMT

I might be wrong, but I think you cant handle this with the standard error messages. As far as I understand the standard error messages, they only cover object-specific/controlled issues e.g. is an object-condition fulfilled or not.

But your condition is based within an expression and based on your actual data (and not on the object).

As a workaround I would suggest to show/hide a textbox with the error message as a layer above your chart with a condition...so it can hide your chart and show the error message.

Re: Change error text...No numeric values on x axis

hariprasadqv — Mon, 27 Apr 2015 03:12:25 GMT

Hi,

If your app is not having any custom error messages other than the one which you specified here,then you can replace all the error message with your wish in the Default mode of custom error messages.

Re: Change error text...No numeric values on x axis

sasikanth — Mon, 27 Apr 2015 04:18:48 GMT

HI,

Try Like this ,

take one text Object and Enable it when ever budget is null

like if(SUM(BUDGET)=0,1,0)

change layout option from Bottom to Top and write the text you want

Re: Change error text...No numeric values on x axis

Mon, 27 Apr 2015 04:35:36 GMT

Yep tried the custom error message but no luck Another overlapping text box should work

Re: Change error text...No numeric values on x axis

Mon, 27 Apr 2015 06:03:14 GMT

Ok, great idea on the chart box.

I fiddled a little and found by setting a calc condition of

=IF(SUM(Budget)=0,0,1)

Then putting the error message text as the text I wanted it finally showed the way I wanted it to!