Hide rows when using status '8'

[Lhelpqlik]

Hi,

Wondering how I could use an expression to hide any rows, that use the status '8' 

i.e

Customer                Job No.  Location.

123Customer.com   1234      8

[Anil_Babu_Samineni]

@Lhelpqlik You can try,

If(Status<>'8', Status)

If it is in set analysis, try with {<Status-={8}>}

[N30fyte]

Hide null values in the Customer dimension. Then in the dimension expression:

=if (Location<>8,Customer)

[Lhelpqlik]

Thank, you but this only removed the location section show '8' i want to remove the whole row of information i.e row hides if use location '8'

[hugo_andrade · Accepted solution]

@Lhelpqlik, 

You can get the result expected by creating a new dimension on the data model that does not contain records that reference Location 8, then use that dimension on a chart. When you do that, make sure yo uncheck the option to "Allow null values". That will remove that entry from the chart.

I've attached an example for you.
🙂

[qv_testing · Accepted solution]

you can try this

If(Status<>'8', Status) as Status at script level

Expression:

add this condition Status -={8} or Status={*}-{8}

[Chanty4u]

Try this

=IF(Location <> '8', Customer)