# New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
New Contributor

## Sum(Count(distinct))

Hi Everyone

I am quite new to Qlik and struggling with fitting Sum(Count(distinct)

In my dashboard I have a requirement to show count of Incidents we have received based on their Priority. Along with this we also want to show what is the percentage of that count of the total number of incident. Following is the expected output..

I am trying to achieve this in a straight table. My challenge is Percentage calculation. The logic should be: Percentage of Distinct Incident to the total number of Incidents.

As show below for example: I have 145 Critical incident and Total incidents are 968. The percentage would be 15.0 (rounded off)

 Priority Count(DISTINCT([Incident Number])) Percentage Critical 145 15.0 High 297 30.7 Low 73 7.5 Medium 453 46.8 Total 968 100

Note: Please note that there must be DISTINCT as same incident can be repeated multiple times.

Regards

Vipin Vij

Tags (4)
1 Solution

Accepted Solutions
Valued Contributor II

## Re: Sum(Count(distinct))

For the Total you can also use the below expression if you want to override the selection in 'Priority' field -

count(TOTAL  {<Priority = >} DISTINCT [Incident Number])

3 Replies
Valued Contributor II

## Re: Sum(Count(distinct))

Check this out

Valued Contributor II

## Re: Sum(Count(distinct))

For the Total you can also use the below expression if you want to override the selection in 'Priority' field -

count(TOTAL  {<Priority = >} DISTINCT [Incident Number])

New Contributor

## Re: Sum(Count(distinct))

Hi @Neelam

It worked like a charm! Bingo

Thanks for this!!