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

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
robotronarkron
Contributor
Contributor

Count distinct activity Id's if milestone type greater than 3 in Financial Year

Good morning QC,

I am new to Qlik Sense working with QVD's.  I would like to script a measure / variable that would count a distinct Activity Id if a specific Milestone Type appears more than 3 times in a financial year  and count distinct if an Activity Id has more than 7 milestones in a financial year regardless of Milestone Type.

I have attached a spreadsheet with sample data

0 Replies