Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Contributor III

zero as null


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.

Tags (1)
2 Replies
Contributor II

Re: zero as null

Replace all your expressions like this

If(Current exp >0,Current Exp,Null())

Honored Contributor III

Re: zero as null

Please provide a sample