Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

handling/cleaning data

I have a table of activities (e.g. boxing, soccer, guitar) and want to produce a simple bar chart with a count of the occurance of each activity. The table is collected from an online form filled in by participants, resulting in, for example 'boxing' being entered as Boxing, or boxing, or BOXING. Each variation in case and spelling results in a separate count, In my example I'd have three different bars in my chart.

Is there any way of dealing with this in the Expression Editor? Or any other recommendations please.

Many thanks, Chris

1 Solution

Accepted Solutions
Anonymous
Not applicable
Author

also you can use capitalize() function in script to bring it to same format

View solution in original post

5 Replies
matteo901p
Partner - Contributor III
Partner - Contributor III

In your script, you can add a field like this
UPPER(activities) as UPPER_DESCFIELD,

In presentation, you add a graph with

DIMENSION: UPPER_DESCFIELD

MEASURE : your expression


OmarBenSalem

you can even do it directly in the presentation; I mean the Upper(activities) as a dimension in your bar chart

Anonymous
Not applicable
Author

also you can use capitalize() function in script to bring it to same format

Anonymous
Not applicable
Author

Awesome. Many thanks for this. Sorry for taking your time. I feel I should have looked this up!

Anonymous
Not applicable
Author

Many thanks. Works very well now.