Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

soniasweety
Contributor III

isnull for only types

Hi all,

addition to this Need Avg for Each

I need to include particular values in  the expression which I am using is

only(if(isnull(Assigned), Number))     it is givning all the values which is null.. but I need for only two which I mentioned for other expression like below

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

and

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

I need :   only(if(isnull(Assigned), Number))         this is giving order and server , solaris also  but  I need the result  as  order and server only

sola.PNG

Tags (2)
3 Replies
arvind_patil
Valued Contributor II

Re: isnull for only types

Hi Sony,

Use below code in Dimension:

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


Thanks,

Arvind patil

soniasweety
Contributor III

Re: isnull for only types

thank you Patil.  it is working

arvind_patil
Valued Contributor II

Re: isnull for only types

Hi Sony,

Please mark It .

Thanks

Arvind Patil