Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikWorld 2020: Join us May 11 - 14, 2020 in Phoenix, AZ. Register early and save $400. Learn More
akpofureenughwu
Contributor III

Distinct Count Error

Hello sir,

I have a set of data I want to do a distinct count for.......

Using this script:

num(count(DISTINCT [ID-Female]), '#,##0')... I can obtain the number of females in my dataset.

I'm trying to get the number of management staff. I used this script:

Count({$<[Cadre] = {'Management Staff'}>} (([ID-NO]) ))

but the figure is not correct... I would love to get a distinct count of all the management staff in my dataset

Thanks

1 Solution

Accepted Solutions
MVP
MVP

Re: Distinct Count Error

May be like:

Count({$<[Cadre] = {'Management Staff'}>}  Distinct [ID-NO] )

View solution in original post

2 Replies
MVP
MVP

Re: Distinct Count Error

May be like:

Count({$<[Cadre] = {'Management Staff'}>}  Distinct [ID-NO] )

View solution in original post

Re: Distinct Count Error

May be this

Count({$<[Cadre] = {'Management Staff'}>} Distinct [ID-NO])

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)