4 Replies Latest reply: Mar 8, 2016 9:15 PM by jagan mohan rao appala RSS

    Count the result of GetFieldSelections()

    Derek Hutchinson

      Hello is there any way to count the result of a GetFieldSelections variable?



      (Sum({<[Sales Rep Goal Percents.Month] = {$(=vMonthSelection)}>}[Sales Rep Goal Percents.Percent]) / (COUNT($(=vMonthSelection)) * 32)) * Sum([Goal Data.2016 GOAL])


      vMonthSelection defined as:



      I want to count the number of months selected if the user selects more than 1 month. I can see that it looks like an array so does Qlik sense support counting selections?


      Please help