4 Replies Latest reply: Feb 1, 2017 9:54 AM by John Schmidt RSS

    Background filter

    John Schmidt

      Hi,

       

      i was wondering if it is possible in Qlik Sense to set a filter for selected charts which cannot be changed by the viewer.

      My problem is, that i have certain KPIs on my sheet which are supposed to show a value for certain dimensions only.

       

      Would be glad for some advice.

       

      Cheers.

        • Re: Background filter
          Michael Solomovich

          I think you need set analysis.  If your chart expression is

          sum(Amount).

          and you want only Country='Sweden' and Product='Qlik', it will be

          sum({<Counrty={'Sweden'},Product={'Qlik'}>} Amount)

           

          Read more in "help"

            • Re: Background filter
              John Schmidt

              Hi,

               

              thanks a lot, this is working so far.

               

              However i have a more complicated issue with filtering an aggregation in my chart.

              I have the following example - data model is designed as a star schema:

               

              Dimensions:

              - Role

              - User

              - Categorie

               

              Fact:

              - Number of tickets

               

              My goal is to show a bar chart with the user names on the x-axis and the number of tickets on the y-axis.

              However, per user i only want to show the number of tickets where the user has the role 'Role X'.

               

              If i do a set analasys like this for a certain user it shows me the right results for that user:

              [ROLE]={'Tester'}, [USER]={'JOHN DOE'},

               

              But i want to show all users - only who have the role 'Tester'.

              If i remove the user-filter the numbers are not right.

               

              Any idea how i would write the analisys?