Count with an Only expression

[LukeWarm1989]

Morning,

I'm trying to count how many tasks are open for a specific name within QLIK sense.

However the name i'm looking to match the count against needs the following expression to pull the name out of our data -

Only({<PIRole_Description={'Adjuster'}>} IF(PIRole_OrganisationName = 'N/A',(PIRole_Firstname &' '& PIRole_Surname),PIRole_OrganisationName))

'---

I'm trying the following with an 'if()' but withno luck and appreciate i've probably botched the expression! Can anyone help and let me know what the heck i'm doing wrong

if(TaskAssigned = (Only({<PIRole_Description={'Adjuster'}>} (PIRole_Firstname &'.'& PIRole_Surname))) ,count({<TaskStatus={'Open'}>} TaskAssigned))

[Anil_Babu_Samineni]

Don't know what you are trying, but assumption this can be hint for you

if(TaskAssigned = Match(PIRole_Description, 'Adjuster') and TaskAssigned = (PIRole_Firstname &'.'& PIRole_Surname) ,count({<TaskStatus={'Open'}>} TaskAssigned))