Skip to main content
Announcements
Meet the 2024 Qlik Luminaries and Partner Ambassadors! READ ON!
cancel
Showing results for 
Search instead for 
Did you mean: 
richard_chilvers
Specialist
Specialist

Omit rows in table with no values

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

1 Solution

Accepted Solutions
Gysbert_Wassenaar

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?


talk is cheap, supply exceeds demand

View solution in original post

3 Replies
Gysbert_Wassenaar

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?


talk is cheap, supply exceeds demand
tresesco
MVP
MVP

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

raadwiptec
Creator II
Creator II

try presnetable tab- supress zero values. if still recurring

in the script mention where field is not null;