Qlik Community

Qlik Sense App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Not applicable

Using a Sum in a count distinct

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?

1 Solution

Accepted Solutions

Re: Using a Sum in a count distinct

May be this:

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

2 Replies

Re: Using a Sum in a count distinct

May be this:

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

Not applicable

Re: Using a Sum in a count distinct

Perfect (and more simple that I expected!)

Thank you!

Community Browser