Discussion board where members can learn more about Qlik Sense App Development and Usage.
I am trying to create a measure out of tickets in Qlik Sense.
This is how the table Looks like:
TicketID Resolver Days
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?
is this ok for you?
please check qvw in attachement
30% of ticket solved in 1 day
another 30% solved in 2
40% solved in 3 or more
hope it's helpfull !!
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.
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
Thats it. My solution is slightly different, but it works. The Performance might be not so good, but it works dynamically.
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))