Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

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.

Tags (3)
1 Solution

Accepted Solutions

Re: Need Avg for Each

May be this

Avg({<Type = {'Order', 'Server'}>} TimeHrs)

and

Count({<Type = {'Order', 'Server'}>} TimeHrs)

16 Replies

Re: Need Avg for Each

May be this

Avg({<Type = {'Order'}>} TimeHrs)

dberkesacn
Contributor III

Re: Need Avg for Each

After you implemented Sunny's great solution I suggest to read this blog.

Average – Which average?

soniasweety
Contributor III

Re: Need Avg for Each

Hi Sunny,

thanks for simple exp;   but I don't want to show in type dimesion and for that also count I dnt want to see in the straight table what is the possibility?

like below screen shot I need only    order and server only.  avg and count rest I dnt want to see

whatever I am showing avg for that only I want to show count and dimesion values.

count.JPG

Re: Need Avg for Each

May be this

Avg({<Type = {'Order', 'Server'}>} TimeHrs)

and

Count({<Type = {'Order', 'Server'}>} TimeHrs)

soniasweety
Contributor III

Re: Need Avg for Each

Yeah sunny its  working

soniasweety
Contributor III

Re: Need Avg for Each

Hi sunny,

I want to show one of field is null for that type values only how to write this exp?

=only( if(IsNull(Assigned), Number))    in this I need to include   'Order', 'Server'

soniasweety
Contributor III

Re: Need Avg for Each

Hi,

Andrey Khoronenko

any suggesitions

tomovangel
Contributor III

Re: Need Avg for Each

I think what you want to see can be done in a text box object , in the description write your expression like this :

=Count({<Type = {'Order', 'Server'}>} TimeHrs)

-Angel

Re: Need Avg for Each

May be like this

=Only({<Type = {'Order', 'Server'}>} If(IsNull(Assigned), Number))

Community Browser