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

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

3 Replies
arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Sony,

Use below code in Dimension:

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


Thanks,

Arvind patil

soniasweety
Master
Master
Author

thank you Patil.  it is working

arvind_patil
Partner - Specialist III
Partner - Specialist III

Hi Sony,

Please mark It .

Thanks

Arvind Patil