Omit rows in table with no values

[richard_chilvers]

I have a straight table (Chart Object) which has Dimensions of Sales Product and Day of Year, and an expression of Sum(Sales).

If a user selects a sales period (eg. March) I would like to only show the rows for products sold on the days for that period. At the moment I am showing EVERY Sales Product, even if every value for the selection is zero.

Any advice?

Thanks

[Gysbert_Wassenaar · Accepted solution]

By default Zero values are suppressed. So either the Suppress Zero Values on the Presentation tab is disables or the values are not really zero, like 0.0000000000001 isn't, or there might be something wrong in your data model that causes your selection to have no effect. Can you post a small qlikview document that demonstrates the issue?

[tresesco]

Check 'Suppress Zero Values' in the presentation tab of the chart.

[raadwiptec]

try presnetable tab- supress zero values. if still recurring

in the script mention where field is not null;