Qlik Community

Ask a Question

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
April 22, 2PM EST: Learn about GeoOperations in Qlik Sense SaaS READ MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Sazabi
Creator
Creator

Qlik Sense Bucketizing Dimension based on string field value

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

 

1 Reply
GaryGiles
Specialist
Specialist

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.