Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Community Browser