Discussion board where members can get started with Qlik Sense.
I am trying to divide 'Count(Distinct Nominee)' by 'Sum HeadCount' to turn it into a percentage.
The current expression I am trying for the divide is:
Sum(Count(Distinct Nominee)/(Sum HeadCount))
Could anyone please let me know where I am going wrong and what I need to correct it to? Thanks!
Is Sum HeadCount a field from your database? May be try this:
Count(DISTINCT Nominee)/ [Sum HeadCount]
I'm not sure what you're trying to accomplish with the outer sum...