how to count the number according the date

[eva_a]

I want to count the total number of employee according the date,

I use the :count({$<TERMINATION_DATE={"<=15/03/2019"},[category]={"H001"},[status]={"N"}>}[YPBI.id]), but it doesnot  work.

Thanks a lot for your help~

[bohravanraj]

Try This :

count({$<TERMINATION_DATE={'<=15/03/2019'},[category]={"H001"},[status]={"N"}>}[YPBI.id])

[eva_a]

still does not  work

[tresesco]

Make sure that the date field date format and the value being passed in set analysis are in same format. You could share your sample aap for our investigation.

[Sue_Macaluso]

@eva_a is this for QlikView or Sense? I would like to move this into the correct product forum. 

[eva_a]

Hi Sue, is QlikSense