Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Not applicable

IF condition in a set analysis ?

How do i write following IF condition in set analysis.

Sum(If(Match(CALL_STATE,'Closed') and ((IPK_STATUS ='Incident' and ACTION_COUNT <> '1')or Match(IPK_STATUS,'Problem')) ,INLIMIT))

Thanks,

Naveen

1 Solution

Accepted Solutions
MVP
MVP

Re: Re: IF condition in a set analysis ?

see attachment, my expressions are compared to your original expression

sum({$<CALL_STATE*={Closed},IPK_STATUS*={Incident},ACTION_COUNT=-{1}> + <CALL_STATE*={Closed},IPK_STATUS*={Problem},ACTION_COUNT=>}

INLIMIT)

5 Replies
srchilukoori
Valued Contributor

Re: IF condition in a set analysis ?

Its best to flag these records as part of the script.

MVP
MVP

Re: IF condition in a set analysis ?

try with

sum({$<CALL_STATE={Closed},IPK_STATUS={Incident},ACTION_COUNT=-{1}> + <CALL_STATE={Closed},IPK_STATUS={Problem},ACTION_COUNT=>}

INLIMIT)

Not applicable

Re: IF condition in a set analysis ?

Hi Massimo,

Thanks for your reply. Your solution works but If I select "Incident" , it also counts"Problem" in the resultset. How do i show only based on current selections.

Thanks,

Naveen

MVP
MVP

Re: Re: IF condition in a set analysis ?

see attachment, my expressions are compared to your original expression

sum({$<CALL_STATE*={Closed},IPK_STATUS*={Incident},ACTION_COUNT=-{1}> + <CALL_STATE*={Closed},IPK_STATUS*={Problem},ACTION_COUNT=>}

INLIMIT)

Not applicable

Re: IF condition in a set analysis ?

Thanks Massimo for your help. It worked like i needed.

Community Browser