Intersection

cbaqir — Mon, 17 Dec 2018 16:26:54 GMT

My requirement: For a DEFECT_ID that has gone through BOTH COM_CAT = 'ART - AMB Refinement Team' and COM_CAT = 'ERC - Routing', what is the current disposition? I tried p() and *= but I can't get seem to figure it out.

Expression: Count( {< DEFECT_ID = p({}) >} DISTINCT DEFECT_ID)

Dimension: =if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Approved'),'Approved', if(Match(COM_CAT,'APT - AMB Prioritization Team') and Match(CUR_STATUS,'Ready for Agenda'),'Waiting for Agenda', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Closed'),'Closed', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Dismissed'),'Dismissed', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Ready for Release'),'Ready for Release', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Building Non-Prod'),'Building/Testing Non-Prod', if(Match(COM_CAT,'ART - AMB Refinement Team') and Match(CUR_STATUS,'Ready for Testing Non-Prod'),'Building/Testing Non-Prod', )))))))

Re: Intersection

Anil_Babu_Samineni — Tue, 18 Dec 2018 00:10:10 GMT

Perhaps this
Count( {< DEFECT_ID = p(DEFECT_ID) >} DISTINCT DEFECT_ID)

Re: Intersection

marcus_sommer — Tue, 18 Dec 2018 11:37:49 GMT

I assume the cause is quite similar like here: If-match-and-match.

I think I would create the needed categories within the script instead of using such large nested if-loops. Further I could imagine that one or maybe several flags could simplify the task especially if your category-values contain a kind of hierarchy.

- Marcus

topic Re: Intersection in QlikView

Intersection

Re: Intersection

Re: Intersection