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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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