filters

[satishqlik]

Hi,

I've two filters Country and  Level and available for all the dashboards.

Now I need to restrict the level only for Brazil- 0.95.

I've tried with with getfieldselections(Country)='Brazil' but not working as I expected.

Kindly suggest if have any other approaches??

Thanks

[JaMajka1]

Hi Satish,

it looks like there is no relation between them. Could you please upload a printscreen of your data model?

BR,

Maria

[Ivan_Bozov]

Use this as dimension for your filter pane Level:

=If(GetFieldSelections(Country)='Brazil', '.95', Level)

[satishqlik]

Hi, Thanks for the response.

In my application,I have 5 dashboards/sheets and Country filter is available for all these dashboards.

Now I need to restrict Country(Australia) in specefic dashboard3/sheet3.

I've tried with below expression in Country filter.

Aggr(Only({<Country=-{'Australia'}>}Country),Country)

Here condition is working fine as I expected and it gives me for all the dashboards.but I need Only for dashboard3/sheet3.

How do we accomplish this please help me out.

Thanks.

[satishqlik]

Hi,

It seems fine in below snapshot.

But If I select .95 from level it's not giving as I expected

Issue occurs in Country and Level showing ALL when I selected Level(.95).

How to overcome from this??

Pls suggest