Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

nareshthavidishetty
Contributor III

zero as null

Hi,

We have 3 filters.

Year

Product

Country

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
qlik4asif
Contributor II

Re: zero as null

Replace all your expressions like this

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

sasiparupudi1
Honored Contributor III

Re: zero as null

Please provide a sample