topic Re: Neede help on conditional expression in QlikView

Neede help on conditional expression

Wed, 30 Jan 2013 16:19:36 GMT

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?

Re: Neede help on conditional expression

khadeer — Wed, 30 Jan 2013 19:14:14 GMT

Hi, U can use this formula,

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

Re: Neede help on conditional expression

jagan — Wed, 30 Jan 2013 19:39:56 GMT

Hi,

Try this expression

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

Hope it helps you.

Regards,

Jagan.

Re: Neede help on conditional expression

Thu, 31 Jan 2013 01:24:58 GMT

Hi.

sum(

if(

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

>5,1,0)

)

Alessandro Furtado

Re: Neede help on conditional expression

Thu, 31 Jan 2013 08:31:50 GMT

ThnX!

Re: Neede help on conditional expression

Thu, 31 Jan 2013 08:34:50 GMT

ThanX Jagan,

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

Grtz. Bart

Re: Neede help on conditional expression

Thu, 31 Jan 2013 08:35:26 GMT

Hi ThnX,

that is simple and straightforward.

Grtz. Bart

Re: Neede help on conditional expression

Thu, 31 Jan 2013 08:48:57 GMT

Hi All,

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

Grtz. Bart

Re: Neede help on conditional expression

Anonymous — Thu, 31 Jan 2013 10:36:41 GMT

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

Regards

MutliView

Re: Neede help on conditional expression

Fri, 01 Feb 2013 08:32:43 GMT

OK, that explains a lot. ThnX!