0 Replies Latest reply: Aug 24, 2015 9:44 AM by Carl Curtis RSS

    Set Analysis - mixing {1} and {$}

    Carl Curtis

      I’m relatively new to Qlik Sense.

       

      My app uses 6 filters, three relating to dates (month,quarter and year) and three relation to employees and groups (employees belong
      to divisions and divisions belong to departments)

       

      I have built and implemented a hierarchy table for the employee>division>department relationships.

       

      Sum({1<NodeID={$(=DepartmentID)}>}Dept_Visits) works great for the employee side of the equation, but I need to add the segment that will follow selections made on the date side.

       

      In short, I need to mix Sum({1}Dept_Visits) and Sum({$}Dept_Visits) in a single statement.

       

      Appreciate any help you can offer.