Limit values of a dimension by using expressions

[Jothi]

Hi, 

I want to limit the values to be displayed for a dimension using expression s

I want to display all values from Name column, except for those, where the SomeSetting Column value is < 4 in the same table. 

Reiterating -  Table1 has 2columns,Name & SomeSetting .

I need to show a bar chart whose dimension is ( Name where SomeSetting < 4)

Something like - Name where isShow = 

[Or · Accepted solution]

When this comes up, my preference is to handle it script-side by using e.g.

Load Name, SomeSetting, if(SomeSetting<4,Name) as NameForChart

From Table1;

And then use NameForChart in your bar chart.

However, you could also handle it on the front end by using a calculated dimension. This may or may not require using aggr() depending on whether SomeSetting is a simple field or a more complex expression.