Qlik Sense Bucketizing Dimension based on string field value

[Sazabi]

Hey Qliksters

Suppose I have this table:

LOAD * INLINE [Name, KPI

Amuro, 782

Alric, 23

Alfonso, 1

Aznable, 23

Betty, 2

Bertha, 3

Beth, 2];

In the front end, I would like to group the calculation by the first letter of a person's name.

Is there a way to write a calculated dimension to do this? Or would I have to add it through the script?

Thanks!

S

[GaryGiles]

You can use a string calculation in a dimension expression, like mid(Name,1,1).  It would definitely more useful if you performed this calculation to create a new field in the load script.  You can't use a function as the field in set analysis or as the field in an aggr function aggr(sum(value), field) or Total <field>, so definitely better to create in the load script if possible.