Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

abhonsle
New Contributor III

Group Dimenion values

Hi All,

I have a dimension called "Company Size" which has the following values  

   

1 - 9
10 - 99
100 - 249
250 - 499
500 - 999
1000+
UNKNOWN

I would like the dimension "Company Size" to roll up to values and show:

UNKNOWN

Small (1-99)

Mid-Market (100-999)

Enterprise (>1000)

Regards,

Ajinkya

1 Solution

Accepted Solutions
MVP
MVP

Re: Group Dimenion values

May be this..

If(Match([Company Size], '1 - 9', '10 - 99'), 'Small (1-99)',

     If(Match([Company Size], '100 - 249', '250 - 499', '500 - 999'), 'Mid-Market (100-999)',

          If(Match([Company Size], '1000+'), 'Enterprise(>1000)', 'UNKNOWN')))

2 Replies
MVP
MVP

Re: Group Dimenion values

May be this..

If(Match([Company Size], '1 - 9', '10 - 99'), 'Small (1-99)',

     If(Match([Company Size], '100 - 249', '250 - 499', '500 - 999'), 'Mid-Market (100-999)',

          If(Match([Company Size], '1000+'), 'Enterprise(>1000)', 'UNKNOWN')))

vkish16161
Contributor III

Re: Group Dimenion values

Maybe use ApplyMap in script?