Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

ccharalamb005
New Contributor

Beginner's question

Hello Everyone,

I would like to ask a sort of a beginners question since i am rather new to this field.

I am looking to create a combo chart in order to represent the total  tickets along with the ticket's average  per week. Where i encounter the problem is calculating the average of the tickets. Using count(Week) basically displays the number of tickets on the specific Week and sum(Week) sums up the number of weeks e.g selecting weeks 5, 8 , 10, 12 it will add up 5+8+10+12, instead of 4 thus the average comes out wrong. What i'm expecting is if i select X random weeks the function should be the total amount of tickets on those X weeks divided by X

If you need any more information please let me know.

Would love to see your replies since the community has taught me a lot.

Thank you!

Tags (1)
1 Solution

Accepted Solutions
MVP
MVP

Re: Beginner's question

Do you have a field called Tickets? May be do this

Count(DISTINCT Ticket_ID)/Count(DISTINCT Week)

or

Avg(Aggr(Count(DISTINCT Ticket_ID), Week))

2 Replies
MVP
MVP

Re: Beginner's question

Do you have a field called Tickets? May be do this

Count(DISTINCT Ticket_ID)/Count(DISTINCT Week)

or

Avg(Aggr(Count(DISTINCT Ticket_ID), Week))

ccharalamb005
New Contributor

Re: Beginner's question

Thanks this works!

Appreciate your help