Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
eva_a
Contributor II
Contributor II

how to count the number according the date

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~
Snipaste_2019-03-22_16-37-35.png

5 Replies
bohravanraj
Partner - Creator II
Partner - Creator II

Try This :

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

eva_a
Contributor II
Contributor II
Author

still does not  work

tresesco
MVP
MVP

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
Community Manager
Community Manager

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

Sue Macaluso
eva_a
Contributor II
Contributor II
Author

Hi Sue, is QlikSense