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:

      =GetFieldSelections([Month])

       

      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