Skip to Content
0

Hide one row ( Restiricted Key Figure) in BEx Query

May 02 at 06:03 PM

43

avatar image

Hi Exprests,

is it possible to hide one and only one row (RKF)? I mean either if specific condition is met (e.g. customer = 1) or this row has null values.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Koen Hesters May 03 at 08:02 AM
1

Hey

you can create a calculated KF:

(CUSTOMER == 1) * RKF

if true value becomes 1 and will show RKF

IF false value becomes 0 and will set 0 as a result

or set (CUSTOMER <> 1)*RKF if you want it the other way around

second step is to set in general properties of query in Rows/Columns to surpress 0 columns

so if whole column is 0, it will be a hidden column

Grtz

Koen

Show 11 Share
10 |10000 characters needed characters left characters exceeded

OK thanks, but other row also may ahve 0/null values and I only want to hide this particular one row, is it possible?

0
Łukasz Kłoczko

it will only hide if whole column OR row OR (column and row), it differs from your setting, is all 0

0

another alternative is to use condition - depending on your condition it will filter out / hide rows

0
0

So there is no way to hide only one particular row without impact on other rows? Like I said, we need hide one RKF if user choose Customer =1 on prompt.

0
Łukasz Kłoczko

I'm sorry but I can't quiet grasp what you are asking exactly, can you share a screenshot of the expected result, please

0

I have a report with multiple RKF in rows:

RKF1

RKF2

RKF3

So if user in prompt pick Customer = 1, then and only then I want to hide RKF3.

0
Łukasz Kłoczko
use RKF in CKF and set entire row to hide when all = 0

if the problem is other rows will/can disappear create an extra CKF with only the condition (Customer==1) so the rows will have a one in the row and the to be hidden a zero.

1

Also, is it possible to hide only one row when values of this row = 0?

0

ok, unfortunately requirements has changed. Now I need hide this RKF when Market = CC and only then. Is it possible?

0
Łukasz Kłoczko

thing is you need to calculate so if you can translate market value "CC" to a key with a number it 'll work like Customer

0