topic Re: ¿How to block the filter in count? in QlikView

¿How to block the filter in count?

Wed, 25 Nov 2020 16:16:04 GMT

Hi there,

I need make a Count() with the variable filter and no variable filter.

I mean, i need count the tickets by week and divide by the total tickets. The follow formule shows the count:

(Count({$<[Task Status]={'closed'},[Task Type]={'CM'}>}[Task ID])>}[Task ID]))/Count([Site ID*])

The problem is in the red part, because i need count the total "Site ID" and not the count "Site ID*" by week.

Best regards

Re: ¿How to block the filter in count?

Gysbert_Wassenaar — Mon, 04 Apr 2016 17:00:05 GMT

Perhaps Count(TOTAL [Site ID*])

Re: ¿How to block the filter in count?

sunny_talwar — Mon, 04 Apr 2016 17:10:51 GMT

Is there a sample you can share with the expected output?

Re: ¿How to block the filter in count?

Mon, 04 Apr 2016 17:11:32 GMT

No, this is a current formule.

Re: ¿How to block the filter in count?

rudolfhbantim — Mon, 04 Apr 2016 18:54:02 GMT

if do you want count side id not considering the dimension, you can use Count(TOTAL Distinct [Site ID*]), but if you want not consider any selections, Count({1}TOTAL Distinct [Site ID*]).

Re: ¿How to block the filter in count?

Tue, 05 Apr 2016 07:35:39 GMT

You can create a variable for total count and then you can use it divide.

Variable:

vTotalCount=Count([Site ID])

Then your final formule will be like below:

=(Count({$<[Task Status]={'closed'},[Task Type]={'CM'}>}[Task ID])>}[Task ID]))/vTotalCount

Re: ¿How to block the filter in count?

tyagishaila — Tue, 05 Apr 2016 08:08:13 GMT

It may be,

Count(Total [Site ID])

I hope You have already tried it. After that did you got your required result or not?

If yes than please close the thread to choose correct answer, and if no than share sample data, to know actual issue.

Cheers.