Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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!!