Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

Highlighted
5abi0001
Contributor

Show average in diagram

Hey! 🙂

I have a question - i have the following problem.

I have a table with the following details:

TicketID,

StartDate,

EndDate,

Employee,

Role

Now what i want to do is to make a diagram (bar chart / line chart). In bars i want to show in calendar weeks, how many tickets were started -> there i made an calculated dimension (WeekName(StartDate)) and so got for every calendar weeks the started tickets - in the formula i used a count to count the tickets.

Now what i want is to show in a line the average - how many tickets were started in average.

And if i select an emloyee i want to see these average for his role and if no employee is selected i want to see the average over all roles.

Sometime it is so, that over the year an employee can change his role - than i watn to see the average for both roles.

I dont now how i should do this.

I hope you can help me. 🙂

5 Replies
5abi0001
Contributor

Re: Show average in diagram

No ideas? 😞

prieper
Honored Contributor II

Re: Show average in diagram

a sample would be helpful ....

Within the datamodel you should link the Employee with his role.

When an Employee is selected, automatically his role(s) will be selected as well.

Expression then may look like:

COUNT({$<Employee = >} Ticket) / COUNT(DISTINCT WeekName)

Expression will count the tickets with the current selections, but not considering the Employee-selection, but it will consider the roles linked with the employee.

Peter

5abi0001
Contributor

Re: Show average in diagram

hey i already linked the employee to his role 🙂

This is what i have now .. i have per calendarweek the started tickets

S2.png

Now what i want is, if no employee is selected i want the average started tickets per role .. it shoudl look like this

S1.png

For the first diagram i have a calculated dimension -> WeekName(StartDate) and in the formula a count the started tickets


Now i dont know how i should realize the second diagram. If no employee is selcted i want to see the average started tcikets per role (there are 3 roles in total).


Employee and Role are already linked in the data model.


prieper
Honored Contributor II

Re: Show average in diagram

can you post an example.

On first glance, you only need to have Role as Dimension

5abi0001
Contributor

Re: Show average in diagram

Hey Peter .. i already managed it! 🙂

I used WeekName(StartDate) as Dimension an created 4 formulas .. one where i count the tickets and show the started tickets and 3 for every role where i divided the sum of tickets for each role trough the numbers of employee which are linked to the role.