Qlik Community

Ask a Question

New to QlikView

If you’re new to QlikView, start with this Discussion Board and get up-to-speed quickly.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
Creator
Creator

How Many employes removed Last 6 Months

Hi Guru's,

I have start date,End date,Count(worker),Manager,Month Year

Dimensions:Month Year,Manager

Expression:Count(workers)

Issue:Count of removed Employees in last 6 Month

1 Solution

Accepted Solutions

=count(DISTINCT {<MonthName1={'>=$(=Date(MonthStart(addmonths(Today(), -6)))) <=$(=Date(MonthEnd(addmonths(Today(), -1))))'} >} Worker)

View solution in original post

8 Replies

Any chance for your data?(Excel,CSV)

Creator
Creator

here is the data

I think, your expression is correct. Try to Give the direct field name instead Qualifier field name.

May be like this

count({<MonthName1={'>=$(=Date(addmonths(Max([End Date]), -6))) <=$(=Date(addmonths(Max([End Date]), 0)))'} >} Worker)

Creator
Creator

Hi All,

As per the data last 6 month 48 Employees are removed.

i want to show last 6 Months  in X axis

Last Six Months mean >=1/1/2015 <=6/30/2015, right?



for me it shows 46, can you provide list of 48 Employees you have?

Creator
Creator

46 is correct,can u post the sample file

so i can implement the same

Partner
Partner

Hi Are Babu,

u can try  expression

 

=

count({<[End Date] ={">=$(=Date(monthstart(addmonths(today(), -6)))) <=$(=Date(addmonths(today(), 0)))"} >} Worker)

=count(DISTINCT {<MonthName1={'>=$(=Date(MonthStart(addmonths(Today(), -6)))) <=$(=Date(MonthEnd(addmonths(Today(), -1))))'} >} Worker)

View solution in original post