Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
QlikWorld happening right now! You can still join: REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
cwhittington05
Contributor II
Contributor II

Count Between Dates

I am trying to create a variable that counts a field between dates.  In another tool my syntax would be:  Count((VISIT_KEY) WHERE APPOINTMENT_DATE BETWEEN '7/1/2021' AND '6/30/2022')

Having some difficult with the syntax in Qlik Sense.  Any assistance would be greatly appreciated.

Labels (1)
2 Replies
Taoufiq_Zarra

@cwhittington05  you can use in Interface set analysis like :

=count({<APPOINTMENT_DATE ={">=7/1/2021<=6/30/2022"} >} VISIT_KEY)

or in script

where APPOINTMENT_DATE>=... and APPOINTMENT_DATE<=...

 

Regards,
Taoufiq ZARRA

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

(you can mark up to 3 "solutions") 😉
cwhittington05
Contributor II
Contributor II
Author

Besides changing "cnt" to "count", this worked perfect! Thanks!