Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Customer & Partners, DEC. 9, 11 AM ET: Qlik Product & Strategy Roadmap Session: Data Analytics REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
wgonzalez
Partner
Partner

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
Partner

for example :

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

wgonzalez
Partner
Partner
Author

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