SUPRESS NULL VALUES dimension also BUT SHOW ZERO VALUES

[qlikcheepirishe]

Hello All,

I have one scenario in pivot chart, where I want to suppress my dimension date field when the expression is null('-')

pfa 

for date 03/22/2019 i want to show row for value(i.e. 03) appearing for date 03/25/2019

remaining null should suppress however i want to show zero also in value column

[dapostolopoylos]

Have you tried the following settings?

[qlikcheepirishe]

When i tick checkbox suppress Zero values then the zero value also disappears i want that also

if value is null in my expression then exclude dimension row field (ie date)

[qlikcheepirishe]

Kindly find excel file