Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

qlikdash
Contributor II

how to 'UNSUPRESS' null or zero values

I have a straight table with 1 dimension and multiple expressions. when the year filter is not selected, rows with null or 0 values are still on display. but when I select on a year or month, rows with null or 0 values go away. I need the rows to stay regardless of null or not.

How do i do that. Thanks

8 Replies
sasikanth
Valued Contributor III

Re: how to 'UNSUPRESS' null or zero values

May be there are no null values in selected Year/Month ,

un check suppress missing and supress zero values

Please share your sample file

sureshqv
Esteemed Contributor III

Re: how to 'UNSUPRESS' null or zero values

chk dis may helpful.

MVP
MVP

Re: how to 'UNSUPRESS' null or zero values

HI,

Try like this

=Sum(Sales) + Sum({<Year-={'*'}>})

Hope this helps you.

Regards,

Jagan.

balrajahlawat
Esteemed Contributor

Re: how to 'UNSUPRESS' null or zero values

may be this?

Properties -> Dimension -> Select any Used Dimesnion(From Top Right) -> Tick Show All values & Untick Suppress Null Values(Right Middle)

hirishv7
Honored Contributor

Re: how to 'UNSUPRESS' null or zero values

Hi,

Try this,

Sum({1-<Year={"*"}>}Sales)+Sum(Sales)

Nulls in Set analysis.PNG

HTH,

Hirish

vsudhakar
Contributor III

Re: how to 'UNSUPRESS' null or zero values

Try this expression it is working  =if(Sum(Sales)='0',0,sum(Sales))

renuka_sasikumar
Contributor III

Re: how to 'UNSUPRESS' null or zero values

Can you share the sample file.

Regards,

Renuka S

sangeethag
New Contributor III

Re: how to 'UNSUPRESS' null or zero values

Hi

If you have zero or null in your data itself, below will work for you.

Properties -> Dimension -> Select any Used Dimension(From Top Right) -> Tick Show All values & Uncheck Suppress Null Values(Right Middle)


Otherwise you have to create dummy data in your table to show null and zero items in the report.

Community Browser