Dynamically hiding row based on value

[Former Member]

I have a situation where if value of column2 (which is calculated KF) value is 0 then I need to hide a complete row. This should happen dynamically through query. How to achieve it?

I know zero suppresion and display/hide option in query designer. But this will not work here as my condition is specific to a value in certain column

If :

Column1        Column2     Column3

A              30             500
B              0              84
C              400            432
D              0              321

Then:

Column1        Column2     Column3

A              30             500
C              400            432

[Former Member]

Hi.

Create 3 additional CKF and set condition on one of them (those KF you may hide in query).

For example:

Col1| Col2| Col3| CKF1 (IF Col1 =0 THEN 1 ELSE 0)| CKF2 (IF Col2 = 0 THEN 1 ELSE 0)| CKF3 (CKF1+CKF2)|

A | 30 | 500| 0 | 0 | 0|

B | 0 | 84 | 1 | 0 | 1|

C | 400| 432| 0 | 0 | 0|

D | 321| 0 | 0 | 1 | 1|

Create condition on CKF3=0.

Regards.

[Former Member]

Hi Andray,

Thanks for the solution. It does help in getting entire row as 0 with this hidden CKF solution. But issue is ZERO SUPRESSION also takes into consideration the values of hidden columns/CKFs. So as the end result even after applying zero suppression we do see those 0 value rows.

Thinking about creating VB macro in workbook for this.

Regards,

Shailesh

[former_member202718]

Hi shailesh ,

Try This .........

Create a Condition and say where Amount NE 0,it will display the Values not Equal to Zero which will satisfy ur condition.

1)Create a new Condition

2)Click on New

3) Choose ur Key Figure with Operator NE 0and Value as Zero. and Save it.

Rgds

SVU123

[Former Member]

Hi SVU,

Thanx.. points assigned...