2 Replies Latest reply: Apr 19, 2016 11:34 AM by Romain Muller RSS

    Using a Sum in a count distinct

    Romain Muller

      Hi,

       

      I am new to QlikSense and trying to solve the following problem:

       

      I want to calculate the number of persons (=count(DISTINCT Gaia)) that had

       

          no utilisation of 3 phone packages ("Intégral standard", "Grand intégral" and "Voix standard"): Sum({<Bundle={"Intégral standard"}>} GrandTotal) + Sum({<Bundle={"Grand intégral"}>} GrandTotal) + Sum({<Bundle={"Voix standard"}>} GrandTotal) =0

       

       

      Combining those doesn't work.

      I think it would be something like that, but i don't find the right syntax:

      COUNT(DISTINCT {<Gaia ={"=Sum({<Bundle={"Intégral standard"}>} GrandTotal) + Sum({<Bundle={"Grand intégral"}>} GrandTotal) + Sum({<Bundle={"Voix standard"}>} GrandTotal) =0"}>} Gaia)

       

       

       

      Does anyone have any suggestions?