Discussion Board for collaboration related to QlikView App Development.
I have one scenario in pivot chart, where I want to suppress my dimension date field when the expression is null('-')
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
Have you tried the following settings?
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)
Kindly find excel file