topic Calculate EMP until Year Month ? in QlikView

Calculate EMP until Year Month ?

Sun, 05 Apr 2015 08:59:36 GMT

Hi all,

I want to calculate the number of EMP until the selection Year:

=Count({$<IsActive={0} , Year={">=$(=Min(Year))} <=$(=Max(Year))"} >} EMP) : this expression works but when I clik on Year and Month, I only see the new EMP in my selection.

Example : I select Year 2014 and Month Feb : I want to calculate EMP from Min Year (2000) to 2014-Feb.

=Count( { $ <IsActive={0} , Year= { "<= $(=Max(Year))" } , MonthYear= { "<= $(=Max(MonthYear))"} >} EMP)

Is it possible to have the same expression with Fiels Year and Month without MonthYear ?

Thanks for your help.

Re: Calculate EMP until Year Month ?

martinpohl — Sun, 05 Apr 2015 09:06:58 GMT

You have to exclude in the formula in calculating.

=Count( { $ <IsActive={0} , Year= { "<= $(=Max(Year))" } , MonthYear= { "<= $(=Max(MonthYear))"} , Month=>} EMP)

Re: Calculate EMP until Year Month ?

Sun, 05 Apr 2015 11:23:32 GMT

Thanks you Martin !!