# 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.
New Contributor II

## Dividing a column by the column total

Hi,

Can someone please tell me the expression for Col 3?

 Col 1 Col 2 Col 3 Name count(val) count(val)/Total(count(val)) A 2 2/14 = 0.14 B 3 3/14 = 0.21 C 5 5/14 = 0.35 D 4 4/14 = 0.28 TOTAL 14

Thanks

1 Solution

Accepted Solutions
Esteemed Contributor

## Re: Dividing a column by the column total

I'd say count(val)/count({<Name=>}total val), with that, even he filter with a name, he'll always get the correct value for the pourcentage in column 3.

If he doesn't do so, he'll get 100% when he select Name=A for example.

3 Replies
MVP

## Re: Dividing a column by the column total

Try this

Count(val)/Count(TOTAL val)

Esteemed Contributor

## Re: Dividing a column by the column total

I'd say count(val)/count({<Name=>}total val), with that, even he filter with a name, he'll always get the correct value for the pourcentage in column 3.

If he doesn't do so, he'll get 100% when he select Name=A for example.

MVP

## Re: Dividing a column by the column total

Sure, sounds like a great idea

Community Browser