topic How to Subtract 2 years from current year in QlikView

How to Subtract 2 years from current year

Anonymous — Mon, 04 Jun 2018 08:25:28 GMT

Hello guys,

I would be thankful if you tell me the awnser ^^

I should to find the total of rookies in the company, So here the calculation :

new year= current year-2

if new year >= 2 , count PERSON_ID where PERSON_TYPE_ID={6}

please help me i couldn't found it

Anil_Babu_Samineni — Mon, 04 Jun 2018 14:55:06 GMT

May be this?

count ({<PERSON_TYPE_ID={6}, year={'$([new year])'}>} PERSON_ID)

Anonymous — Sat, 09 Jun 2018 00:42:03 GMT

Thank You very much ..

but may be i didn't explain my problem very well..!!

I have to count the total number of rokkies in the company so i have these data:

1- count({<PERSON_TYPE_ID={6}>}distinct PERSON_ID) . (These for count Total employees)

2- I should subtract from Current Date -2

3- I should subtract Current date from Date Start if the result >=2 then count it as rookies

DateStart-Current date >=2 ,Count ({<PERSON_TYPE_ID={6}>}distinct PERSON_ID)

How can I solve it could you please help me!