Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Read about the latest Qlik Community enhancements on the Community News blog!
Showing results for 
Search instead for 
Did you mean: 
Contributor III
Contributor III

Group values in expression

I have a block chart and I currently have an expression to count statuses.  I'd like to group some of these statuses into a 'new' category.  Instead of doing this in the script, can I define it in Expressions?

For example I'd like to say

if([Dashboard Status]='In Progress' OR [Dashboard Status]='Design', 'In Queue', 'xxx')

Thank you.

3 Replies
Specialist III
Specialist III

it would be better if you do as a calculated dimension instead, of using the expression, but yes it can be done

Specialist III
Specialist III

Hi Jen,

You can definitely Achieve the new category.

Use Pick() and Match functions.

See below.

PICK(MATCH([Dashboard Status],'In Progress' ,'Design'), 'In Queue', 'xxx')

let me know if you have any questions.


Contributor III
Contributor III

Got it! Thank you!