# Qlik Sense App Development

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

New Contributor III

## Count if result incorrect after a selection

Hello,

I am doing some test in this sample data :

 Machine_ID Date Num_Incident 1 2016 101452400 1 2016 101452406 1 2016 101452000 1 2016 101452447 1 2016 101452451 1 2016 101452452 1 2016 101452496 1 2017 101452000 1 2017 101452591 1 2017 101452597 1 2018 101452601 1 2018 101452614 1 2019 101452621 2 2017 101452000 2 2017 101452682 2 2017 101452690 2 2017 101452829 2 2017 101452835 2 2017 101452842 2 2017 101452843 2 2018 101452000 2 2018 101452907 2 2019 101452911 2 2019 101452915 2 2019 101452916 2 2019 101452918 2 2019 101452000 2 2019 101452922 2 2019 101452923 2 2019 101452924 2 2019 101452928 3 2018 101452940 3 2018 101452941 3 2018 101452944 3 2018 101452000 3 2018 101452961 3 2018 101453035 3 2018 101453000 3 2018 101453042 3 2019 101453048

I am trying to do a count distinct Num_Incident if Num_Incident finish with a triple 0. I have used with the formula : Count(distinct {<Num_Incident={"*000"}>} Num_Incident). The formula return the total value of 2 which is the correct answer (match the Num_Incident of 101452000 and 101453000).

But here is the issue, when I filter in a selection box Num_Incident with whatever value, the count distinct still return 2. If I select for example Num_Incident = 101453042, I still get value 2 while I am supposed to get no value.

Can anyone know a solution for this, please ?

Best regards,

Clément Boyer

Labels (3)

• ### selection

1 Solution

Accepted Solutions
MVP

## Re: Count if result incorrect after a selection

Try this expression... added * before the equal sign within the set analysis....

``Count(DISTINCT {<Num_Incident *= {"*000"}>} Num_Incident)``

2 Replies
MVP

## Re: Count if result incorrect after a selection

Try this expression... added * before the equal sign within the set analysis....

``Count(DISTINCT {<Num_Incident *= {"*000"}>} Num_Incident)``

New Contributor III

## Re: Count if result incorrect after a selection

It works perfectly, thank you.