Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
wgonzalez
Partner - Creator
Partner - Creator

Set Analysis: selection of specific group

Hi,

I need to make a calculation with a specific group of employees in a table where there are three groups of them (PayGrp).  There's a multi box in the application that allows the user to select a group for which the charts/pivot tables will do the calculation.  Since the transactions are associated with the employees QV is making the calculation using those employees associated with the transactions, but I still need to calculate using the whole selected group, not only those in the transactions.

How can I specify the whole population of the selected group to do the calcs?  See the data model attached.

2 Replies
giakoum
Partner - Master II
Partner - Master II

for example :

sum({$<paygroup]=>} [value])

wgonzalez
Partner - Creator
Partner - Creator
Author

I would need to do that for each Expresion in the object.  I'm wondering if there's something more straightforward.