Neede help on conditional expression

[#1]

I need to count the occurrences of Projects with more than 5 members.

So far I have constructed this formula:

=Count(DISTINCT if(count([Project Team Member Name])>5,[Project ID]))

but that isn't right. I think I am mistaking in the syntax - any ideas?

[khadeer]

Hi, U can use this formula,

=if(Count([Project Team Member Name]))>5,count([Project ID]))

[jagan]

Hi,

Try this expression

=Count({<[Project ID]={"=Count(DISTINCT [Project Team Member Name])>5"}>} [Project ID])

Hope it helps you.

Regards,

Jagan.

[#4]

Hi.

sum(

        if(

          aggr( count(DISTINCT [Project Team Member Name]),[Project ID])

          >5,1,0)

       )

Alessandro Furtado

[#5]

ThnX!

[#6]

ThanX Jagan,

I am new to this language… what is the logic behind the {} and <> ?

Grtz. Bart

[#7]

Hi ThnX,

that is simple and straightforward.

Grtz. Bart

[#8]

Hi All,

ThanX for your answers. Got three different results now, so will be checking which one is the right one.

Grtz. Bart

[Anonymous]

Its QlikView Set Analysis you can read about it on this link

Regards

MutliView

[#10]

OK, that explains a lot. ThnX!