Discussion board where members can get started with QlikView.
We have 3 filters.
Chart: Pivot table
We the user selects year we have data for only 2018 and remaing all are zeros.
We the user selects product = Mobile we have data and remaing all were zeros.
Here the user needs like they don't want to see zeros when the user selects a year
and they want to see zeros for other selections.
Finally for time dimension we need to supress zeros if they select any year and if any zeros they need to supress.
Replace all your expressions like this
If(Current exp >0,Current Exp,Null())
Please provide a sample