topic Re: Count a count in QlikView

Count a count

charlesdmeyer — Sat, 16 Nov 2024 17:43:57 GMT

I am working on some data about our student body. I used formula this to determine the number of failing grades that each student has: count({<[Current Grade]={"<70%"}>}[Student ID]) and it is accurate.

Now I want a count of the number of students who have four failures based on the count from the formula, three failures, etc.

I have tried Aggr, but I might be doing it wrong.

Any help is greatly appreciated.

Re: Count a count

Kushal_Chawda — Mon, 07 Dec 2020 22:42:58 GMT

@charlesdmeyer may be this for four failure. you can then adjust accordingly

= Count({<[Student ID] ={"=count({<[Current Grade]={'<70%'}>}[Student ID])<5 "}>}[Student ID])

Updated expression with single quotes inside inner set

Re: Count a count

edwin — Mon, 07 Dec 2020 22:27:40 GMT

one simple way is to use an if statement:

if(count({<[Current Grade]={"<70%"}>}[Student ID])>=4,1)

if there is no filtering required, you can add the aggregation in your script - create a field with count or grades <70% and you can use that in your expression

count({<Failures={">=4"}>}StudentID)

Re: Count a count

edwin — Mon, 07 Dec 2020 22:28:08 GMT

hope that helps or at least points you to rt/alternative direction