Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
joshi_qlikview
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
settu_periasamy
Master III
Master III

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

View solution in original post

8 Replies
robert_mika
Master III
Master III

Any chance for your data?(Excel,CSV)

joshi_qlikview
Creator
Creator
Author

here is the data

settu_periasamy
Master III
Master III

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)

joshi_qlikview
Creator
Creator
Author

Hi All,

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

i want to show last 6 Months  in X axis

settu_periasamy
Master III
Master III

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?

joshi_qlikview
Creator
Creator
Author

46 is correct,can u post the sample file

so i can implement the same

perumal_41
Partner
Partner

Hi Are Babu,

u can try  expression

 

=

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

settu_periasamy
Master III
Master III

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

View solution in original post