Skip to Content
0

WEBI Hide Rows

Aug 09, 2017 at 05:51 PM

110

avatar image

Hello,

I am trying to hide rows conditionally in a WEBI report v4.1. The highlighted row below is a sample of what I need to hide. If structure row is 'Estimated Savings' and measures are blank/0, then hide the row. My variable is the column on the right and displays Hide so seems to be working.

But the measure results display UNAVAILABLE when adding a filter to the table using my HideRow variable.

T

I have researched the forums and found 1 similar issue but gives no solution.

Please advise.

Thanks,

Roseanne

nssqv.png (12.4 kB)
tyou9.png (17.7 kB)
lttnd.png (16.0 kB)
10 |10000 characters needed characters left characters exceeded

Hi,

Try Inlist() than = sign.

Also, if you only want to hide when measure is 0 or null then it would be good practice to have variable defined only to hide null or Zeros.

If([A]=0 or is null([A])) then Hide;display

Thanks,

Jothi

0
Thanks for responding.

I do want to hide if the measures are 0 or null but only for certain rows in the structure.

I tried inlist as well and still getting UNAVAILABLE.

0
* Please Login or Register to Answer, Follow or Comment.

4 Answers

AMIT KUMAR
Aug 09, 2017 at 07:57 PM
0

try to create your variable as measure and see.

Share
10 |10000 characters needed characters left characters exceeded
Roseanne Crysler Aug 10, 2017 at 12:31 PM
0

Thanks much for your response.

To keep it simple, I created the variable as this and receiving same results. The filter is on the table (vertical).


dxc12.png (31.2 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 11, 2017 at 07:41 PM
0

Hi Roseanne,

Why can't you try 0 or 1 instead of using Hide and Display and make it as a measure and try.

Thanks,

Durga

Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Aug 14, 2017 at 01:11 PM
0

Why not use the format table options to hide the blank/0 rows?


akj6v.png (15.0 kB)
Share
10 |10000 characters needed characters left characters exceeded