topic Re: Error message not showing in chart? in QlikView

Error message not showing in chart?

Thu, 27 Mar 2014 12:48:32 GMT

Hi,

Acn anyone let me know why the message is not showing. I don't want to supress zero values or supress missing values.

I would need to show if there are no values it should populate as 'No fail'

Dimension: Error Code

Expression : If(Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID))=0,'No Fail',
Sum({<[Overall Result]={'Fail'}>} [Error Flag])/Count(Distinct(ID)))

Thanks.

Re: Error message not showing in chart?

Thu, 27 Mar 2014 12:49:00 GMT

Please see attached.

Re: Error message not showing in chart?

alexandros17 — Thu, 27 Mar 2014 12:49:22 GMT

Uncheck "exclude zero values" check box

Re: Error message not showing in chart?

Thu, 27 Mar 2014 12:53:15 GMT

Thanks. where can I uncheck this in bar chart?

Re: Error message not showing in chart?

MK_QSL — Thu, 27 Mar 2014 12:54:20 GMT

Go to dimension tab and select show all values

Go to Expression tab and untick Show values on datapoints

Now copy the same expression and create a 2nd expression

Untick Bar and Tick Text on axis..

Re: Error message not showing in chart?

alexandros17 — Thu, 27 Mar 2014 12:55:21 GMT

right click on the object -> properties

presentation tab -> suppress zero values

Re: Error message not showing in chart?

Thu, 27 Mar 2014 13:00:30 GMT

Thanks. It is looking messy in the chart Is there anything I need to change?

Re: Error message not showing in chart?

MK_QSL — Thu, 27 Mar 2014 13:02:44 GMT

GO to presentation tab

Chart Scrolling

Tick Enable X-Axis Scrollbar

when number of items exceed (10 or whatever you want)

Re: Re: Error message not showing in chart?

sudeepkm — Thu, 27 Mar 2014 13:04:09 GMT

You may have to use a scroll bar enable in your chart due to huge data points.

Please take a look at the attachment. As Manish suggested Text on Axis is your solution.

Re: Error message not showing in chart?

ashwanin — Thu, 27 Mar 2014 13:05:25 GMT

hi, Your expression is ok,

You just need to Check the 'Text on Axis' under Chart -->presentation tab.

I checked it and found the it reflects

Re: Error message not showing in chart?

Thu, 27 Mar 2014 13:06:41 GMT

Thanks. Perfect

Re: Error message not showing in chart?

Thu, 27 Mar 2014 13:09:48 GMT

Is there any way to show only fail text instead of all?