Divide column values by a variable

Anonymous — Thu, 02 Jun 2016 18:52:17 GMT

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!

Re: Divide column values by a variable

oknotsen — Thu, 02 Jun 2016 19:08:53 GMT

No need for that variable.

Use sum(count)/sum(TOTAL count)

Re: Divide column values by a variable

sunny_talwar — Thu, 02 Jun 2016 19:11:14 GMT

Try this:

Count/Sum(TOTAL Count)

Re: Divide column values by a variable

Anonymous — Thu, 02 Jun 2016 19:26:19 GMT

Fantastic! Thanks Sunny

topic Re: Divide column values by a variable in App Development

Divide column values by a variable

Re: Divide column values by a variable

Re: Divide column values by a variable

Re: Divide column values by a variable