Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
No need for that variable.
Use sum(count)/sum(TOTAL count)
Try this:
Count/Sum(TOTAL Count)
Fantastic! Thanks Sunny