Set Analysis : Year()

[mithunr40]

How to calculate the number of employees hired in 2008 (HIRE_DATE). They given me the fields and functions to use in set analysis: EMPLOYEE_ID, HIRE_DATE, year().

I can't use logic in the backend and i just want to show in the front end in expression. 

Please help me to solve this problem.

Thank you.

[MartW]

Count({<HIRE_DATE={'=$(=year(makedate(2008,1,1)))'}>} EMPLOYEE_ID )

[mithunr40]

Thank you for your answer @MartW  but it taking all the date and i think i want only 2008 data only .

[MartW]

that is strange. I tested this with some dummy data and I got only the 2008 ID's back in Qlik.

is it possible for you to share a snippet of the data?

[mithunr40]

I am unable to see any data from this sheet it just showing me wrong answer that's it.

[tresB]

Try like:

Count({<HIRE_DATE={"=Year(HIRE_DATE)=2018"}>} EMPLOYEE_ID )

Note: If your date field data is text/string type, it might not work; then you have to convert strings to date type values in script or change the expression a bit using date#()

[mithunr40]

Thank you for your response @tresB but here they given me like one page so on that i want to paste the expression i can't see any datamodel or value

[Pavanvh]

You can use any of the below.

Count({<DATE = {'2008'}>}EMP_ID)

or

Count({<DATE={'$(=year(makedate(2008,1,1)))'}>} EMP_ID )

[mithunr40]

Hi @Pavanvh it's not working.

[tresB · Accepted solution]

If you are going thorugh an assignment/interview, it is also important to ask right questions. In general, the solution I provided earlier - should work, otherwise - you may need to include distinct like:

Count(Distinct {<HIRE_DATE={"=Year(HIRE_DATE)=2018"}>} EMPLOYEE_ID )