topic Omit rows in table with no values in QlikView

Omit rows in table with no values

richard_chilvers — Wed, 13 Apr 2016 09:06:54 GMT

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

Re: Omit rows in table with no values

Gysbert_Wassenaar — Wed, 13 Apr 2016 09:09:39 GMT

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?

Re: Omit rows in table with no values

tresB — Wed, 13 Apr 2016 09:09:56 GMT

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

Re: Omit rows in table with no values

raadwiptec — Wed, 13 Apr 2016 09:11:16 GMT

try presnetable tab- supress zero values. if still recurring

in the script mention where field is not null;