Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
oliveton
Creator
Creator

Why is Some of My Data Missing From Chart but Present in Table Box?

Hello,

This is driving me crazy. I have a set of data and I'm trying to make sure none of it is missing from my chart.

When I make a table box everything seems to be there; then when doing a double check in my chart I find numbers from %MahleCram to be missing. An example is %MahleCram number BX1. I'm not sure if my expression is somehow causing this to happen.

I did a noconcatenate for the one file I loaded to make sure everything was brought over but I guess that wasn't the way to go.

Please help! Thanks!

1 Solution

Accepted Solutions
settu_periasamy
Master III
Master III

Hi,

Yes. all your expression showing null and getting suppressed.

your example , %MahleCram as 'BX1'.

For Testing , Just add 1 in your expression and check that.

Capture.JPG

Or Uncheck 'Suppress Zero Value' in the Presentation Tab.

View solution in original post

3 Replies
isingh30
Specialist
Specialist

Can you highlight some data in your application? The one which is missing.

settu_periasamy
Master III
Master III

Hi,

Yes. all your expression showing null and getting suppressed.

your example , %MahleCram as 'BX1'.

For Testing , Just add 1 in your expression and check that.

Capture.JPG

Or Uncheck 'Suppress Zero Value' in the Presentation Tab.

oliveton
Creator
Creator
Author

Wow......yes all I had to do was uncheck "Suppress Zero Value" I got fixated on the fact "Suppress When Value is Null" was unchecked so nothing should be hidden.

Thank you!!