Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable
‎2016-09-07 05:50 AM

Count distinct?

I have the following data and as can be seen there is one row for each question, each of these rows have the same (assignment)number.

How can I count how many different (assignment)numbers I have? Right now when I count I get 13 times as many as I would like as the (assignment) number appears 13 times for each questionaire.

Thanks!

2,266 Views
0 Likes
13 Replies
Anonymous
Not applicable
‎2016-09-08 05:13 AM
Author

I ended up using the following expression to do the count: Count( distinct number)

343 Views
0 Likes
sunny_talwar
MVP
MVP
‎2016-09-08 05:15 AM

In response to Anonymous

But wasn't this proposed by okolyug16‌ already? If this is what worked for you, I would suggest marking there response as the correct answer instead of your own.

Thanks,

Sunny

343 Views
0 Likes
ToniKautto
Employee
Employee
‎2016-09-08 06:02 AM

In response to Anonymous

To be fair I did not see the number field in your initial screenshot.

343 Views
0 Likes
Anonymous
Not applicable
‎2016-09-08 06:05 AM
Author

In response to sunny_talwar

Yes sorry, of course!

343 Views