Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Highlighted
starter888
New Contributor

How to count qualitative data & create bar charts in analysis

Hi everyone

I have a table with lots of qualitative data and am trying to create charts to analyse them. The fields are something like this:

CustomerMain IssueSecond Issue
ACMESlow processingCustomer Service
JovanOnline bookingsCustomer Service
Regional ASlow processingOnline bookings
   

 

I want to be able to create a visualisation that tells me the % of Main Issue, and then another one with the % of the Second Issue.

Many thanks from a beginner!

1 Solution

Accepted Solutions
JordyWegman
Valued Contributor

Re: How to count qualitative data & create bar charts in analysis

Hi Starter,

You can do the following:

Make a Bar Chart

 

Dimension: Main Issue
Measure 1: Count([Main Issue]) / Count(TOTAL [Main Issue])

Do this also for the Second Issue etc.2019-02-08 16_06_59-.pngExample for Main and Second Issue

 Jordy

Climber

2 Replies
JordyWegman
Valued Contributor

Re: How to count qualitative data & create bar charts in analysis

Hi Starter,

You can do the following:

Make a Bar Chart

 

Dimension: Main Issue
Measure 1: Count([Main Issue]) / Count(TOTAL [Main Issue])

Do this also for the Second Issue etc.2019-02-08 16_06_59-.pngExample for Main and Second Issue

 Jordy

Climber

starter888
New Contributor

Re: How to count qualitative data & create bar charts in analysis

Thanks Jordy for the quick help 🙂 

 

It worked!