topic Re: how to suppress rows with 0's and '-' in QlikView

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

Fri, 12 Aug 2011 15:12:10 GMT

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

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

Fri, 12 Aug 2011 15:22:13 GMT

I am trying to supress rows in straight table

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

Fri, 12 Aug 2011 15:27:49 GMT

You can try a calculated dimension, something like this

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

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

=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!

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

Fri, 12 Aug 2011 15:38:56 GMT

=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 ......

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

swuehl — Fri, 12 Aug 2011 15:39:56 GMT

Maybe

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

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

Fri, 12 Aug 2011 15:51:25 GMT

Try

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

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

swuehl — Fri, 12 Aug 2011 15:56:51 GMT

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.

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

Fri, 12 Aug 2011 15:57:22 GMT

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

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

swuehl — Fri, 12 Aug 2011 16:06:21 GMT

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

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

swuehl — Fri, 12 Aug 2011 16:16:15 GMT

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

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

SunilChauhan — Fri, 12 Aug 2011 17:52:47 GMT

if( isnull(donors)=0,donors)

then supress null

hope this works

if not understand correctly then share a sample.

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

Fri, 12 Aug 2011 18:13:31 GMT

I supreesd nulls so I eliminated 0's but still m getting '_' . How should I supress the rows having '_'

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

swuehl — Fri, 12 Aug 2011 19:06:30 GMT

Please describe your current setting, by listing your (calculated?) dimension and your expressions.

Or post your application here (upload available in the advanced editor).

It's getting hard to know what your problem is, also too many different approaches around.

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

Sun, 14 Aug 2011 10:06:55 GMT

Hi Pramodreddy,

You want to supress all the rows with 0 donors in 2010. If I understand what you asking, is that you want to do so regardless of what you had as donors in 2009 (in the sam rows) ?

Ok, since " Sum({$<CAMPAIGNYEAR ={ $(vCurrentYear)},TrackParam.CAMPAIGNSTATUS={'F'},TrackParam.CAMPAIGNACCOUNT={'18'},TrackParam.CAMPAIGNTYPE={'empl'}>}TrackParm.NUMBEROFDONORS) " is the expression that calculate the numbers of donors for the current year, I think you should just write the following code with an "If" condition, try it out:

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

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

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

swarup_malli — Tue, 16 Aug 2011 18:07:36 GMT

Pramod,

If(sum({$<CAMPAIGNYEAR = {$(=num(vCurrentYear))},TrackParm.CAMPAIGNSTATUS = {"F"},TrackParm.CAMPAIGNACCOUNT = {"18"},TrackParm.CAMPAIGNTYPE= {"empl"}>}TrackParm.NUMBEROFDONORS)>0 or Null(), sum({$<CAMPAIGNYEAR = {$(=num(vCurrentYear-1))},TrackParm.CAMPAIGNSTATUS = {"F"},TrackParm.CAMPAIGNACCOUNT = {"18"},TrackParm.CAMPAIGNTYPE= {"empl"}>}TrackParm.NUMBEROFDONORS))

This should work

Regards

Swarup

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

Tue, 16 Aug 2011 18:10:35 GMT

It worked!!!