Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

c3curtis
New Contributor

Set Analysis - mixing {1} and {$}

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.