Divide column values by a variable

[Anonymous]

Hi All,

Is it possible to add a calculated column to a table object in Qlik Sense? I've been spinning my wheels for a bit and could use some help. Here's my scenario and attempted solution

Scenario: Say I have a dataset with a couple columns 'Process' & 'Count', and I want to display the count of each process as a percentage of the total count in a column as shown below;  

Process	Count	Percent
A	5	33.33%
B	1	6.67%
C	3	20.00%
D	4	26.67%
E	2	13.33%

Attempted Solution: Declare the total count as a variable(SumCount), then create a measure with expression (Count/$(SumCount))*100. This doesn't work, it gives a column with all 100 values.

Attached is a sample qvf.

Thanks!

[oknotsen]

No need for that variable.

Use sum(count)/sum(TOTAL count)

[sunny_talwar · Accepted solution]

Try this:

Count/Sum(TOTAL Count)

[Anonymous]

Fantastic! Thanks Sunny