Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Re: How to Count and Group By

Try this

Count(TOTAL <ID> {<STATE = {'VALID'}>} ID) * Avg(1)

jaarroyl
New Contributor III

Re: How to Count and Group By

It didnt work.

The same before.

Re: How to Count and Group By

It seems to be working for me...

Without selection

Capture.PNG

INVALID Selected

Capture.PNG

VALID Selected

Capture.PNG

Highlighted
jaarroyl
New Contributor III

Re: How to Count and Group By

It Works, you rigth. Thanks you

Re: How to Count and Group By

okay nice