topic Count Distinct Project ID in QlikView

Count Distinct Project ID

Mon, 08 Dec 2014 18:56:51 GMT

Hello all,

I can't seem to get this query to work properly.

Here is what I want to do:

Exclude certain project status

Count Distinct Project IDs within the Project Details Table

count(
{<
[Project Status]-={'Project AWARDED', 'COMPLETED', 'Project CANCELLED', 'ON HOLD'}
>}
DISTINCT
[Project Details.Project ID]

As always any help is greatly appreciated.

Regards,

Myles

its_anandrjs — Mon, 08 Dec 2014 19:14:27 GMT

Hi,

Your expression is correct if you want to exclude all this 'Project AWARDED', 'COMPLETED', 'Project CANCELLED', 'ON HOLD' status

count( DISTINCT
{<
[Project Status]-={'Project AWARDED', 'COMPLETED', 'Project CANCELLED', 'ON HOLD'}
>}

[Project Details.Project ID] )

Regards

Anand

Mon, 08 Dec 2014 20:13:04 GMT

Hi Anand,

This worked great! Thank you!

Regards,

Myles

its_anandrjs — Mon, 08 Dec 2014 20:19:59 GMT

Thanks it works for you please close the thread by appropriate answer.

Regards

Anand