Count Between Dates

[cwhittington05]

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.

[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<=...

[cwhittington05]

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