Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
@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<=...