# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
cancel
Showing results for
Did you mean:
Contributor II

## How to calculate percentage in Qlik Sense Table

Hello,

I'm very new to Qlik Sense and am having difficulty calculating percentages in a table - based on my web searches, this seems to be a common problem so I'm hoping someone can help me!

The table I'm trying to build shows data around online learning courses - specifically, how many people in each team have completed the course.

The table currently shows columns in the following order: The groups of staff (Team), how many staff are in that team (Total Learners), and how many of the staff have competed the learning course (Total Completed).

I'm trying to add a column on the end which will tell me what percentage of the Total Learners have Completed the learning.

For example:

Team             Total Learners           Total Completed       Completion Rate %

Team 1                  80                                      40                                        50%

Team 2                  10                                        8                                        80%

Does anyone know what formula I would need to use for this?

Thanks,

Beth

1 Solution

Accepted Solutions
Partner - Master III

maybe i am over simplifying it. but its quite straight forward

create measure with

ExpressionForCompleted/ExpressionforTotalLearners

if its a straight table you could also do something like Column(1)/column(2)

2 Replies
Partner - Master III

maybe i am over simplifying it. but its quite straight forward

create measure with

ExpressionForCompleted/ExpressionforTotalLearners

if its a straight table you could also do something like Column(1)/column(2)

Contributor II
Author

Well now I feel rather silly for not realising this sooner - thanks so much for your help!