Set Analysis - mixing {1} and {$}

Anonymous — Mon, 24 Aug 2015 13:44:09 GMT

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.

topic Set Analysis - mixing {1} and {$} in App Development

Set Analysis - mixing {1} and {$}