Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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> )
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
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.
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..
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