topic Re: Count Employees that's not affected by filters in QlikView

Count Employees that's not affected by filters

Sun, 14 May 2017 18:09:11 GMT

Hi, I have an expression which goes like this:

=sum({1}aggr(sum({<dept={'IT'}>}Empid), Empid))

I was hoping to count employees under IT department which does not change regardless of the selection. i tried adding {1} before aggr but it still change. I also tried adding before Empid of Sum but it counts everything, disregarding my set analysis.. Thank you in advance for the help.

Re: Count Employees that's not affected by filters

Frank_Hartmann — Mon, 15 May 2017 15:53:51 GMT

please share a sample qvw which demonstrates the problem

Re: Count Employees that's not affected by filters

Digvijay_Singh — Mon, 15 May 2017 16:03:47 GMT

Can you try this -

=sum({1<dept={'IT'}>}aggr(sum({1<dept={'IT'}>}Empid), Empid))

Re: Count Employees that's not affected by filters

Anil_Babu_Samineni — Mon, 15 May 2017 16:22:59 GMT

Or this?

sum(aggr(sum({1<dept={'IT'}>}Empid), Empid))