Set Analysis: selection of specific group

wgonzalez — Mon, 30 Jul 2012 13:39:39 GMT

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.

Re: Set Analysis: selection of specific group

giakoum — Mon, 30 Jul 2012 13:41:51 GMT

for example :

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

Re: Set Analysis: selection of specific group

wgonzalez — Tue, 31 Jul 2012 17:24:54 GMT

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

topic Re: Set Analysis: selection of specific group in QlikView

Set Analysis: selection of specific group

Re: Set Analysis: selection of specific group

Re: Set Analysis: selection of specific group