Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
BI & Data Trends 2021. Discover the top 10 trends emerging in today. Join us on Dec. 8th REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Contributor II
Contributor II

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
Highlighted
Contributor II
Contributor II

Done! Thanks Again