topic SUPRESS NULL VALUES dimension also BUT SHOW ZERO VALUES in QlikView

SUPRESS NULL VALUES dimension also BUT SHOW ZERO VALUES

qlikcheepirishe — Fri, 12 Apr 2019 08:12:58 GMT

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 — Fri, 12 Apr 2019 08:32:27 GMT

Have you tried the following settings?

qlikcheepirishe — Fri, 12 Apr 2019 09:10:04 GMT

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 — Fri, 12 Apr 2019 11:35:50 GMT

Kindly find excel file