Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
soniasweety
Master
Master

Need Avg for Each

Hi all,

I want to calculate count and avg hrs of each type of numbers  to particular .

attached excel with sample example.

can anyone suggest the way?

only some of the Type values to be shown.

avgData.PNG

Thanks

Sony.

16 Replies
soniasweety
Master
Master
Author

Ok sunny,

Sunny Talwar

Thanks. till now that is working fine. let you know if anything change required.

small doubt. if I want to do on some other filter values how can I write?

means other field name is  group= '@oreta ', '@emea'    instead of  type   and I want dimension as type only?

here if I filter in data with above group only that group related types should display in table.

hope this is clear

Thanks

Sony

sunny_talwar

Not sure I understand... can you elaborate?

soniasweety
Master
Master
Author

oreta.PNG

sunny_talwar

May be like this in set analysis

{<Group = {'Oreta', 'emea'}>}

soniasweety
Master
Master
Author

in dimension I have given this

If(Wildmatch(Type,'Order', 'Server'),Type)

is it fine?  or it make any issue? or i can use direct Type as dimension?

sunny_talwar

It is usually more efficient to use set analysis rather than calculated dimensions, but what you just posted above should also work

soniasweety
Master
Master
Author

Okay sunny thank you for clarification

Thanks

Sony