how to suppress rows with 0's and '-'

[#1]

I am working on information related to donors, for years 2010 and 2009. I want to supress the rows which is having 0 donors in 2010. I have to use either setanalysis or if cond...but I am unable to do...please help me

[#2]

I am trying to supress rows in straight table

[#3]

You can try a calculated dimension, something like this

=IF(ExpresionField='','',DimensionField)

Or

=IF(ExpresionField=null(),'',DimensionField)

Or

=IF(ExpresionField=0,'',DimensionField)

Depending on the ExpresionField data.

Then you need to check on Suppress when value is null on the dimensions tab and also you may want to do this, check on the Presentation tab Suppress Zero-Values and Suppress Missing.

But remember that this could take to many resources depending on the number of records.

Best Regards!

[#4]

=IF(Sum({$<CAMPAIGNYEAR ={ $(vCurrentYear)},TrackParam.CAMPAIGNSTATUS={'F'},TrackParam.CAMPAIGNACCOUNT={'18'},TrackParam.CAMPAIGNTYPE={'empl'}>}TrackParm.NUMBEROFDONORS)=0,'_',Organizations.NAME1)

tq for your help but I am getting error while caluculating this expression ......

[swuehl]

Maybe

=if( Year= 2009 or donors>0, donors)

?

[#6]

Try

=IF(Sum({$<CAMPAIGNYEAR ={ $(vCurrentYear)},TrackParam.CAMPAIGNSTATUS={'F'},TrackParam.CAMPAIGNACCOUNT={'18'},TrackParam.CAMPAIGNTYPE={'empl'}>}TrackParm.NUMBEROFDONORS)='','',Organizations.NAME1)

[swuehl]

Ah, I forgot the you still have the zero values for 2009, which you want to see.

Add a expression with

=if( Year= 2009 or donors>0, 1)

This expression is only to filter the rows.

check supress zero values, hide the new expression.

See also attached sample.

Regards,

Stefan

[#8]

its not working, Actually I want values greator than 0. Only values greator than 0 should be displayed and other rows should be suppressed

[swuehl]

So do you want to suppress all rows regardless the year with donors=0?

Just check "supress zero-values" in presentation tab (like also with my other suggestion).

I think nothing else needed.

P.S. That will not work with multiple expression columns, showing different data <> 0

I believe Qlikview will only supress rows if all expression values shown are zero.

edited by swuehl

[swuehl]

Maybe you could describe a bit closer your setting,

what is/are your dimension(s), what are your expressions.

It would be good if you could post an example application to the forum.

Regards,

Stefan