Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to Count and Group different values in a column?

Hi All,

New to Qlik Sense, and manipulation of data.

I'm trying to count certain values in a column then have them grouped up and displayed as a sum of one number.

For example:

This is what values are in a column:

L0 Status
Awaiting Feedback from Business/BA
Estimate Completed
Estimate Requested (Past Due Date)
Request Approved
Request Approved (Funded Supplier)
Cancelled

I want all the 'Awaiting Feedback', 'Estimate Completed', 'Estimate Requested' to be counted together and displayed as 'In Progress'

Any help is appreciated.

Thanks

10 Replies
Anonymous
Not applicable
Author

Done! Thanks Again