topic Re: Qlik Sense Bucketizing Dimension based on string field value in App Development

Qlik Sense Bucketizing Dimension based on string field value

Sazabi — Mon, 01 Feb 2021 22:12:38 GMT

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!

Re: Qlik Sense Bucketizing Dimension based on string field value

GaryGiles — Mon, 01 Feb 2021 23:30:37 GMT

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.