topic Re: IF condition in a set analysis ? in QlikView

IF condition in a set analysis ?

Sat, 22 Mar 2014 23:14:49 GMT

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

Re: IF condition in a set analysis ?

srchilukoori — Sat, 22 Mar 2014 23:21:57 GMT

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

Re: IF condition in a set analysis ?

maxgro — Sun, 23 Mar 2014 00:04:32 GMT

try with

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

INLIMIT)

Re: IF condition in a set analysis ?

Sun, 23 Mar 2014 05:22:08 GMT

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

Re: Re: IF condition in a set analysis ?

maxgro — Sun, 23 Mar 2014 08:01:40 GMT

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)

Re: IF condition in a set analysis ?

Sun, 23 Mar 2014 20:33:31 GMT

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