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

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

NenadV — Wed, 13 Aug 2025 08:54:13 GMT

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

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

PrashantSangle — Wed, 13 Aug 2025 09:14:16 GMT

try this

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

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

NenadV — Wed, 13 Aug 2025 09:41:46 GMT

Thanks Prashant.

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

marcus_sommer — Wed, 13 Aug 2025 10:18:12 GMT

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))

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

NenadV — Wed, 13 Aug 2025 10:25:14 GMT

Thank you Marcus.

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