4 Replies Latest reply: Sep 18, 2018 8:26 AM by satish qlik RSS

    filters

    satish qlik

      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

        • Re: filters
          Maria Sandorova

          Hi Satish,

           

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

           

          BR,

          Maria

          • Re: filters
            Ivan Bozov

            Use this as dimension for your filter pane Level:

             

            =If(GetFieldSelections(Country)='Brazil', '.95', Level)
            
            
              • Re: filters
                satish qlik

                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.

                • Re: filters
                  satish qlik

                  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