4 Replies Latest reply: Oct 1, 2018 3:27 AM by Casper Westelaken RSS

    Removing limitation if a filter is present

    Casper Westelaken

      Hello,

       

      I do not know whether or not this actually is possible.
      Currently I've got a table with 1 dimension and 6 measures. The dimension being Employee.
      The table is focused on service management with the first measure being TSOC.

       

      Since the table lists all employees, even those not involved in service management, I wanted to apply a limitation to prevent a large amount of rows without any values other than null or 0.
      Sadly the limitation is only calculated on the first measure.

       

      As a result, applying this limitation will remove the rows with differing values in the other colums (from the other measures) where this information could still be valuable.

       

      By clicking on the 'Others' row Qliksense applies a filter that selects all Employees included in 'Others'.

       

      What I was hoping to achieve was that when a filter is applied, the limitation on the table is removed. Is this possible?

       

      Yours Sincerely,
      Casper Westelaken

        • Re: Removing limitation if a filter is present
          Shahbaz Khan Mohammed

          use a variable with combination of if conditions?

          What are the expressions you are using, what expressions should hide and what should show?

            • Re: Removing limitation if a filter is present
              Casper Westelaken

              Since I was struggling I do not have much atm. After trying a few things I stopped at:

               

              if(GetPossibleCount(Employee)>=1,0,null)

               

              Problem with that being that it doesn't actually have any effect. If there is no selection the amount of possible Employees is > 1, if there is a selection it is at least 1. When the selection of all 'Others' is used there still are > 1 possible Employees.

               

              So I'm trying to figure out what I need to use to determine that the 'Others' filter is in effect more than anything.
              Considering the potential of a variable amount of Employees, and a variable amount of Employees that will have the value of 0 on the limited measure I cannot simply put a predetermined number for the limitation.

               

              In my current dataset I've got 185 Employees, of which 38 fall in the 'Others' category.

                • Re: Removing limitation if a filter is present
                  Shahbaz Khan Mohammed

                  if(getselectedcount(Employee)>0, YOUREXPRESSION,

                  if(Employees='Others', YourExpression for others))

                   

                  If I misunderstood you then could you please tell..

                  if Employee is selected what number shoud show up

                  If it is not selected what should show

                  If others is selected what to show

                    • Re: Removing limitation if a filter is present
                      Casper Westelaken

                      Hmm, I don't think you misunderstood me, but it doesn't seem to work. Nor does me fiddling around with the getselectedcount (I didn't realize this existed)

                       

                      I'll add a few screenshots, those might clear things up.

                      Without Limitation.png
                      This is what the table looks like without any limitation. Due to this being messy (to me) I wanted to get rid of all the rows with just zeros.

                       

                      To do this I'd like to apply a limitation.

                      With Limitation.png
                      With a basic limitation of 0 this is the end result. The problem lies in the next screenshot.

                      With filter.png

                       

                      Due to the limitation still being 0 it won't show detailed insight into the 'Others'.

                       

                      None of the expressions described by you or tried by me have worked sadly.

                       

                      Medewerker = Employee by the way.

                       

                      Thanks for the help up till now!
                      Casper