Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
May be this:
Count(DISTINCT {<Gaia ={"=Sum({<Bundle={'Intégral standard', 'Grand intégral', 'Voix standard'}>} GrandTotal) = 0"}>} Gaia)
May be this:
Count(DISTINCT {<Gaia ={"=Sum({<Bundle={'Intégral standard', 'Grand intégral', 'Voix standard'}>} GrandTotal) = 0"}>} Gaia)
Perfect (and more simple that I expected!)
Thank you!