Counting records before a given date

ZoeM — Sat, 16 Nov 2024 03:57:00 GMT

Hello Community!

I am creating a KPI where I am looking to count records from start of year through today. The one issue I am facing is that my dates are coming in through a date bridge and so I have to specify my syntax that way in the Set Analysis expression:

= Count({$<[Date Type]={'VPP Dates'},Reference_Only={'No'}>}Gateways)

I saw the below expression from one of the other blogs:

=Count({<TStartDate={"$(='>=' & Date(Today(), 'DateFieldFormatHere') & '<=' & Date(Today()+14, 'DateFieldFormatHere'))"}>} TCode)

but I am unsure of how to restructure my expression because of "[Date Type]={'VPP Dates'}"

Any help rendered will be truly appreciated.

topic Counting records before a given date in QlikView

Counting records before a given date