Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
eva_a
New 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

Tags (1)
5 Replies
Partner
Partner

Re: how to count the number according the date

Try This :

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

eva_a
New Contributor II

Re: how to count the number according the date

still does not  work

MVP
MVP

Re: how to count the number according the date

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.

 

Community Manager
Community Manager

Re: how to count the number according the date

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

Sue Macaluso
eva_a
New Contributor II

Re: how to count the number according the date

Hi Sue, is QlikSense