Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted

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

View solution in original post

8 Replies
Highlighted

Any chance for your data?(Excel,CSV)

Highlighted
Creator
Creator

here is the data

Highlighted

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)

Highlighted
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

Highlighted

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?

Highlighted
Creator
Creator

46 is correct,can u post the sample file

so i can implement the same

Highlighted
Partner
Partner

Hi Are Babu,

u can try  expression

 

=

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

Highlighted

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

View solution in original post