Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Jnkansayeboah
Contributor
Contributor

How do I count IDs within a particular date range?

I want to count a particular set of ID numbers within a particular fiscal year. I have started with the code below, but it is currently not working. Can anyone help correct the code please?

Count({<[Event Date]={">=$((Date($(vMinFiscalYear),'DD/MM/YYYY'))) <=$((Date($(vMaxFiscalYear),'DD/MM/YYYY')))">}[IDs])

1 Reply
Taoufiq_Zarra

@Jnkansayeboah 

can you try

Count({<[Event Date]= {"<=$(=Date(vMaxFiscalYear,'DD/MM/YYYY')) >=$(=Date(vMinFiscalYear,'DD/MM/YYYY'))"}> } [IDs])
Regards,
Taoufiq ZARRA

"Please LIKE posts and "Accept as Solution" if the provided solution is helpful "

(you can mark up to 3 "solutions") 😉