Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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 (1)
0 Replies