Qlik Community

App Development

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

Showing results for 
Search instead for 
Did you mean: 

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.

0 Replies