Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Set Analysis help!!!!

can someone help convert this into set anlysis code thanks

COUNT (If (Comp_Status = 'WorkingWith' AND Terr_ChildCount = 0 AND isNull(Comp_Deleted),Comp_Status))

3 Replies
perumal_41
Partner - Specialist II
Partner - Specialist II

COUNT ({<Comp_Status ={ 'WorkingWith' }, Terr_ChildCount = {0} AND Comp_Deleted={''}>}Comp_Status)

Try this expresion.

jagan
Luminary Alumni
Luminary Alumni

Hi,

Try this expression

=Count( {<Comp_Status={'WorkingWith'}, Terr_ChildCount={'0'}, Comp_Deleted-={'*'}>} Comp_Status)

Regards,

jagan.

Not applicable
Author

Hi, Try this code:

=Count({<Comp_Status={'WorkingWith'},Terr_ChildCount={0}>}if(isNull(Comp_Deleted)=-1,Comp_Status))