topic x-axis showing null value in QlikView

x-axis showing null value

Thu, 23 Aug 2012 10:42:03 GMT

I am getting one bar for Null values in my bar graph, but when i am checking my data, there is no record with the Null value in my table. Can anybody tell me why, i am getting this bar for NUll value?

Re: x-axis showing null value

Anonymous — Thu, 23 Aug 2012 10:50:47 GMT

this basically means that there are some values returned by your expression which are not getting linked to the dimension..

if your dimension is from a different table... check the link between the tables..

usually this will be the problem..

let me know if this is not the case here..

hope that helps..

Re: x-axis showing null value

advait_thakur — Thu, 23 Aug 2012 11:00:41 GMT

Hello,

Please check in Chart Properties> Dimensions > Settings for Selected Dimension > Suppress When Value is Null.

Also in Presentation tab you can flag in Suppress Missing.

I hope this will help you.

Thanks,

Advait

Re: x-axis showing null value

Thu, 23 Aug 2012 11:04:24 GMT

Hey adavit, thanks for the reply but this was the thing which i knew, i just wanted to know the exact reason for that bar showing Null values.

Re: x-axis showing null value

advait_thakur — Thu, 23 Aug 2012 11:42:11 GMT

Hello,

The association between the tables is not being formed properly.

Kindly check the joins, concatenations if you have any.

Thanks,

Advait