topic Re: Suppress rows depending on the value of a particular expression in QlikView

Suppress rows depending on the value of a particular expression

swarup_malli — Wed, 18 Mar 2015 15:21:15 GMT

I have a straight table with 6 dims and 20 expressions .Its a detailed table I building for the business users who plan to export it to excel.

Currently the table shows all the rows ,I only want to show the rows when a particular expression has the value '1' in it and suppress when the value of this expression is zero.

I know I can use something like this

if ( my expression < 1 , null(),expression),

This approach means I have to code this in all 20 expressions present in the table ,which is a real pain in the neck ;-(

I'm planning to create 80 charts of the same type

I can start a new thread from here any ideas

Re: Suppress rows depending on the value of a particular expression

rubenmarin — Wed, 18 Mar 2015 15:29:47 GMT

Hi swarup, if your last dimension has unique values (not the same value in different segments) you can transform your last dimension to a conditional dimension like:

Aggr(If(your_expression>0, DimensionFieldName), DimensionFieldName)

Re: Suppress rows depending on the value of a particular expression

JonnyPoole — Wed, 18 Mar 2015 15:31:13 GMT

You could try variablizing a portion of that expression 'if ( my expression < 1,null() ' and combining that in the expression editor for a little less neck pain ?

Or consider doing it in a dimension if you only have a few of those but it could introduce some slower performance (with aggr() etc..)

Re: Suppress rows depending on the value of a particular expression

swarup_malli — Wed, 18 Mar 2015 16:56:00 GMT

Thank you ! Guys

Re: Suppress rows depending on the value of a particular expression

rwunderlich — Thu, 19 Mar 2015 03:44:51 GMT

I believe you can deal with the concern of requiring unique values in the Dimensions by specifying all Dimensions in the aggr. For example, you could code the first Dim as

=aggr(if(sum(Expression3)>30, Dim1), Dim1, Dim2, Dim3)

And then suppress when null. You would only need to do this for one Dimension, just include the complete list of Dims in the aggr. See attached,

-Rob

http://masterssummit.com

http://robwunderlich.com

Re: Suppress rows depending on the value of a particular expression

swarup_malli — Fri, 20 Mar 2015 21:25:06 GMT

Thank you ! Guys