Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, is it possible to count the number of instances of where one date field in the record is less than another date field, for example
In table 1 i have
ID Type Date Occurred
1 A 01/03/2022
2 B 01/02/2022
In table 2 i have
Type Expired Date
A 07/03/2022
B 12/02/2022
So qlik joins the row data by type, so all four fields are available in a table,
I want to count instances where the Date Occurred < Expired Date
Thanks
count({<[Date Occurred]={"<$([Expired Date])"}>} ID)