Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
jim_chan
Specialist
Specialist

How to group a list of data value in a dimension?

Hi guys,

I have a dimension which full of deals. but based on requirement, the deals have to be split or group to BIG deal and Small Deal.

I have created an exmapple here as per attached.

What i want is:

1) Group value ABCD into BIG Deal, rest of it without typing EFGH, will be group into Small Deals.

screenshot6.jpg

1 Solution

Accepted Solutions
tresesco
MVP
MVP

You can use expression like:

=If(Match(Deals, 'a', 'b', 'c', 'd'), 'Big Deals', 'Small Deals')

View solution in original post

1 Reply
tresesco
MVP
MVP

You can use expression like:

=If(Match(Deals, 'a', 'b', 'c', 'd'), 'Big Deals', 'Small Deals')