Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Expression to work out a percentage

Hi All,

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!

2 Replies

Re: Expression to work out a percentage

Is Sum HeadCount a field from your database? May be try this:

Count(DISTINCT Nominee)/ [Sum HeadCount]

Re: Expression to work out a percentage

Count(Distinct Nominee)/Sum(HeadCount)


I'm not sure what you're trying to accomplish with the outer sum...

Community Browser