Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Highlighted
Not applicable

Count Distinct Project ID

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

1 Solution

Accepted Solutions

Re: Count Distinct Project ID

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

3 Replies

Re: Count Distinct Project ID

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

Not applicable

Re: Count Distinct Project ID

Hi Anand,

This worked great! Thank you!

Regards,

Myles

Re: Count Distinct Project ID

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

Regards

Anand