This content has been marked as final. Show 3 replies
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;
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.