topic Hide/Show entire row in QlikView

Hide/Show entire row

engishfaque — Fri, 20 Nov 2020 18:02:30 GMT

Dear All,

I have a table where I'm using expressions.

My last expression is To Order = Field1 + Field2 + Field3

This expression give me positive and negative number regarding quantity.

Now, I want to show only those records where To Order is greater than 0.

Current Output:

Project Field1 Field2 Field3 To Order

A 2 2 1 5

B -9 1 1 -7

C 1 1 1 3

Required Output (Supress those rows where To Order > 0):

Project Field1 Field2 Field3 To Order

A 2 2 1 5

C 1 1 1 3

Please note, To Order calculated based on complex expression.

Kind regards,

Ishfaque Ahmed

Re: Hide/Show entire row

JonnyPoole — Wed, 25 Feb 2015 19:13:24 GMT

You could variablize the complicated expression and then reference it in each expression. Then ensure you have suppress zero values checked on the presentation tab propertiers.

To Order: if ( vComplicatedExpression. > 0 , vComplicatedExpression )

Field1: if ( vComplicatedExpression > 0 , <existingfield1expression> )

Field2: if ( vComplicatedExpression > 0 , <existingfield2expression> )

Field3: if ( vComplicatedExpression > 0 , <existingfield3expression> )

Re: Hide/Show entire row

engishfaque — Wed, 25 Feb 2015 20:05:09 GMT

Dear Jonathan,

I assigned expression to variable and using in a required column, but Suppress Zero-Values are working.

Being I mark checked to Check box Suppress Zero-Values.

Kind regards,

Ishfaque Ahmed

Re: Hide/Show entire row

JonnyPoole — Wed, 25 Feb 2015 20:15:55 GMT

Ok. You can try manually assigning 0 below in the expressions for when the condition is not met. Or , you can try leaving the expressions as above and ensue you have 'suppress missing' on the presentation tab properties.

To Order: if ( vComplicatedExpression. > 0 , vComplicatedExpression , 0 )

Field1: if ( vComplicatedExpression > 0 , <existingfield1expression>, 0 )

Field2: if ( vComplicatedExpression > 0 , <existingfield2expression> , 0)

Field3: if ( vComplicatedExpression > 0 , <existingfield3expression>, 0 )

If neither work , then you can try to replace your dimension with a calculated dimension that does the same but the syntax may need to be different (aggr()) in that context.

If none of these work i'd like to see a sample or real QVW that illustrate the problem to check things out.

Re: Hide/Show entire row

MK_QSL — Wed, 25 Feb 2015 20:34:47 GMT

You have to give same condition for whatever number of expressions you have used..

If(To Order Expression > 0, Field1 Expression, 0)

same way calculate Field2, Field3, To Order

Now Suppress Zero Values from presentation tab..

Re: Hide/Show entire row

Anonymous — Thu, 26 Feb 2015 06:52:30 GMT

Hi Ishfaque,

You can add the same filed under Dimention tab and check the "Supress When Value is Null" check box.

You can hide this column under presentation tab.

Hope this helps.

Regards,

Laxmi