Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

aboumejjane
Contributor

Removing missing value

Hi Guys,

For some reason I have a missing value in my bar chart. When I look at the field (Date), I see that field is not missing any value nor are they incorrect. My question is how can I find out what's causing the missing value to appear? Or how can I remove the missing value?

missing month.bmp

Thanks in advance!

iSam

1 Solution

Accepted Solutions
MVP
MVP

Removing missing value

Hi iSam,

I think you could try "Supress if value is Null" in dimension tab of your chart.

I would prefer checking why you get a Late count with no referenced date though. You may try to select the records by clicking on the bar and checking in a table box or similar, on which record this count is based on.

Regards,

Stefan

4 Replies

Re: Removing missing value

Hi,

Use Suppress zero null checked select field and select suppress zero null in the preperties of chart. I suggest you i think due to some conditions the data get filtered due to that you are seeing null there thats why a - symbol is display.

Rgds

Anand

MVP
MVP

Removing missing value

Hi iSam,

I think you could try "Supress if value is Null" in dimension tab of your chart.

I would prefer checking why you get a Late count with no referenced date though. You may try to select the records by clicking on the bar and checking in a table box or similar, on which record this count is based on.

Regards,

Stefan

Re: Removing missing value

Hi,

You check your chart by suppress Zero null value in the chart properties.

Rgds

Anand

aboumejjane
Contributor

Re: Removing missing value

Hi Stefan,

Thanks! Your right. That would be better. There was a date missing a excel sheet. That was causing the missing value. Thanks for the eye-opener.

Cheers!

iSam

Community Browser