# App Development

Announcements
Qlik Cloud Maintenance is scheduled between March 27-30. Visit Qlik Cloud Status page for more details.
cancel
Showing results for
Did you mean:
Contributor III

## 80% of tickets solved in x days as chart function, how?

Dear community,

I am trying to create a measure out of tickets in Qlik Sense.

This is how the table Looks like:

TicketID    Resolver Days

1                1

2                 1

3                 1

4                 2

5                2

6               2

7                3

8                5

9                6

10               6

So I want to calculate that 80% of tickets are solved in 2,125 days.

In Excel I would sort the tickets after resolver days (ascending, because I want the fastest result). Eruate what 80% out of 10 data rows is (8). Sum up these rows (17) and calculate their average (17/8).

I need this as a Chart function and not been precalculated in the script.

How can this be done?

6 Replies
Partner - Creator III

is this ok for you?

QlikView Qlik Sense consultant
Partner - Creator III

30% of ticket solved in 1 day

another 30% solved in 2

40% solved in 3 or more

QlikView Qlik Sense consultant
Contributor III
Author

Good approach, but that is not the solution I am looking for. In a diagram there would be the Resolution days on the y-axis and the percentage (maybe in 10% steps) on the x-axis.

I want to have the percentages dynamically. Maybe at firsdt "only" in a table.

MVP

Not entirely sure how you got to 2,125... but may be see if this link helps or provide a better sample to help you better here

Recipe for a Pareto Analysis – Revisited

Contributor III
Author

Thats it. My solution is slightly different, but it works. The Performance might be not so good, but it works dynamically.

DIMENSION

=Aggr(

If(Rangesum(Above(Count( [Incident Number])/Count(total [Incident Number]),0,RowNo()))<=0.80, '0-80%',
If(Rangesum(Above(Count( [Incident Number])/Count(total [Incident Number]),0,RowNo()))<=0.9, '80-90%', '90-100%')),

([Incident Number],(=Sum( ResolutionDays),Asc))

)

KEY FIGURE

Sum(ResolutionDays)

/

Count([Incident Number])

MVP

Superb!!

Tags
Community Browser