Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Announcements
QlikWorld, June 24-25, 2020. Free virtual event for DI and DA gurus. Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Specialist III
Specialist 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
Highlighted
Partner
Partner

Re: isnull for only types

Hi Sony,

Use below code in Dimension:

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


Thanks,

Arvind patil

Highlighted
Specialist III
Specialist III

Re: isnull for only types

thank you Patil.  it is working

Highlighted
Partner
Partner

Re: isnull for only types

Hi Sony,

Please mark It .

Thanks

Arvind Patil