Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Count Employees that's not affected by filters

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.

3 Replies
Frank_Hartmann
Honored Contributor

Re: Count Employees that's not affected by filters

please share a sample qvw which demonstrates the problem

Digvijay_Singh
Honored Contributor III

Re: Count Employees that's not affected by filters

Can you try this -

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

Re: Count Employees that's not affected by filters

Or this?

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

Life is so rich, and we need to respect to the life !!!
Community Browser