Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.
chrislowther
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
kulwantsaj219
Contributor II

Re: handling/cleaning data

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

5 Replies
matteo901p
New Contributor III

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


OmarBenSalem
Esteemed Contributor

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

kulwantsaj219
Contributor II

Re: handling/cleaning data

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

chrislowther
New Contributor

Re: handling/cleaning data

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

chrislowther
New Contributor

Re: handling/cleaning data

Many thanks. Works very well now.

Community Browser