Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Contributor II

Counting records before a given date

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.