Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Talk to Experts, a LIVE Q&A Webinar. Bring your Qlik Sense Business questions on Aug. 4th. Register
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator II
Creator II

filters

Hi,

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

cap1.PNG

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

Tags (1)
4 Replies
Highlighted
Partner
Partner

Re: filters

Hi Satish,

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

BR,

Maria

Highlighted
Luminary
Luminary

Re: filters

Use this as dimension for your filter pane Level:

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

Highlighted
Creator II
Creator II

Re: filters

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.

Highlighted
Creator II
Creator II

Re: filters

Hi,

It seems fine in below snapshot.

snp1.JPG

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

snp11.JPG

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

How to overcome from this??

Pls suggest