Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
ZoeM
Specialist
Specialist

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. 

Labels (3)
0 Replies