Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
jmarotte
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
ramoncova06
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

krishna_2644
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.

krishna

jmarotte
Contributor III
Contributor III
Author

Got it! Thank you!