Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QLIKWORLD LIVE! MAY 16 - 19TH, EARLY BIRD DISCOUNTS! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Neede help on conditional expression

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?

9 Replies
khadeer_sparks
Specialist
Specialist

Hi, U can use this formula,

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

jagan
MVP
MVP

Hi,

Try this expression

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

Hope it helps you.

Regards,

Jagan.


Not applicable
Author

Hi.

sum(

        if(

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

          >5,1,0)

       )

Alessandro Furtado

Not applicable
Author

ThnX!

Not applicable
Author

ThanX Jagan,

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

Grtz. Bart

Not applicable
Author

Hi ThnX,

that is simple and straightforward.

Grtz. Bart

Not applicable
Author

Hi All,

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

Grtz. Bart

multiview
Creator II
Creator II

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

Regards

MutliView

Not applicable
Author

OK, that explains a lot. ThnX!