Qlik Community

Ask a Question

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
March 11, 2PM EST: Do More with Qlik - Getting Started wtih Qlik Sense SaaS - Redux. REGISTER NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
rerebecky
Contributor
Contributor

categorising/grouping measure in scatter group

Hi, I would like to categorize the revenue measure of the scatter graph to, 'below 500', 'between 500 to 999', 'between 1000 to 1499', 'above 1500'. however, the following expression doesn't work.

Aggr(Sum(if([Revenue]<=500, 'below 500',

If([Revenue]>=500 and [Revenue}<=999, 'between 500 to 999',

If([Revenue]>=1000 and [Revenue}<=1499, 'between 1000 to 1499',

If([Revenue]>=1500, 'above 1500', 'Others'))))))

Could any one find out what are the mistakes? Thanks!

 

Labels (3)
1 Solution

Accepted Solutions
lironbaram
Partner
Partner

hi first of all 

when using aggr function you need to give a dimension to run the aggr on 

Aggr(if(Sum([Revenue])<=500, 'below 500',

If(Sum([Revenue])>=500 and Sum([Revenue])<=999, 'between 500 to 999',

If(Sum([Revenue])>=1000 and Sum([Revenue])<=1499, 'between 1000 to 1499',

If(Sum([Revenue])>=1500, 'above 1500', 'Others')))),YOUR_DIMENSION)

View solution in original post

1 Reply
lironbaram
Partner
Partner

hi first of all 

when using aggr function you need to give a dimension to run the aggr on 

Aggr(if(Sum([Revenue])<=500, 'below 500',

If(Sum([Revenue])>=500 and Sum([Revenue])<=999, 'between 500 to 999',

If(Sum([Revenue])>=1000 and Sum([Revenue])<=1499, 'between 1000 to 1499',

If(Sum([Revenue])>=1500, 'above 1500', 'Others')))),YOUR_DIMENSION)

View solution in original post