New to QlikView

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

Announcements
Talk to Experts Tuesday, January 26th at 10AM EST: Qlik Sense. REGISTER NOW
cancel
Showing results for
Search instead for
Did you mean:
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)

8 Replies
MVP

Any chance for your data?(Excel,CSV)

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

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

46 is correct,can u post the sample file

so i can implement the same

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)

Tags