0 Replies Latest reply: Nov 4, 2018 6:17 PM by Robert Arklay RSS

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

    Robert Arklay

      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