Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Support Cases coming to Qlik Community Oct. 4! Start chats, open cases, explore resources: READ DETAILS
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!