Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Save the Date: QlikWorld Online, June 24-25, 2020. Free global virtual event for data integration and data analytic gurus. Register Today
Highlighted
New Contributor

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
Highlighted
Contributor II

Re: handling/cleaning data

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

View solution in original post

5 Replies
Highlighted
Partner
Partner

Re: handling/cleaning data

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


Highlighted
Partner
Partner

Re: handling/cleaning data

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

Highlighted
Contributor II

Re: handling/cleaning data

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

View solution in original post

Highlighted
New Contributor

Re: handling/cleaning data

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

Highlighted
New Contributor

Re: handling/cleaning data

Many thanks. Works very well now.