In QlikView how to classify age in groups of 10 starting with 15?

[NenadV]

Hi,

I would like to group employee age in groups of 10 starting at 15.

This calculated dimension: 

=dual(replace(class(Age, 10), '<= x <','-'),class(Age, 10))

gives this:

thank you

[PrashantSangle · Accepted solution]

try this

class(Age,10,'-',5 )

[NenadV · Accepted solution]

Thanks Prashant.

[marcus_sommer]

In addition to the suggestion from @PrashantSangle the third parameter replaced only the x but not the <= > chars. Therefore the replace within a dual() is further needed if a different view is wanted. But the fourth parameter is useful to adjust the bucket-size to a fix offset-value.

On top of it you may wrap the Age with a rangemax() and/or rangemin() if the start- and end-bucket should be limited to a certain number of buckets and may in the end looking like:

= dual(replace(class(rangemin(66, rangemax(15, Age)),10,'',5), ' <= < ', ' - '),
                        class(rangemin(66, rangemax(15, Age)),10,'',5))

[NenadV]

Thank you Marcus.

Replacing '-' with 'X' in Prashant's solution is fine with me.