Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Not applicable
‎2012-03-12 06:23 PM

Calculated Dimension to Create Groups

I am new to Qlikbook and I am having difficulty returning the correct sum of the quantity sold by customer.  I am trying to break the quantity purchased by customer into brackets (<12, 12-19, 20-29, etc) by Year.

Dimensions

I am using the following Dimensions - Calculated Dimension, Year

Here is the calculated dimension expression that I created. (QVOF = Quantity)

=If((QVOF<12),'<12',If((QVOF>=12 and QVOF<20),'12-19',If((QVOF>=20 and QVOF<30),'20-29',If((QVOF>=30 and QVOF<40),'30-39',If((QVOF>=40 and QVOF<80),'40-79','80+')))))

Expressions

sum(QVOF)

I am then graphing the data by Year

Do I need to use the AGGR function?

530 Views
0 Likes
1 Reply
swuehl
MVP
MVP
‎2012-03-12 07:35 PM

Not sure if I fully understood what you want to achieve, but your calculated dimension and your expression look ok to me at first glance - what problems do you have in detail?

Could you give an example of your result and what you expect?

146 Views
0 Likes