topic Re: Count when not Primary in QlikView

Count when not Primary

cbaqir — Wed, 06 Nov 2019 14:56:33 GMT

I need to show a count of DEFECT_ID where a resource is the PRIMARY_ASSIGNEE and then also when they are not the PRIMARY_ASSIGNEE but they are listed as one of the BUILD_RESOURCES_SUB (subfield that contains only user name). How can I calculate the secondary?

Dimension: PRIMARY_ASSIGNEE

Exp Count Primary: count(DISTINCT DEFECT_ID)

Exp Count Secondary: Count(DISTINCT{$<BUILD_RESOURCES_SUB-={'PRIMARY_ASSIGNEE'}>}DEFECT_ID)

Re: Count when not Primary

Anil_Babu_Samineni — Wed, 06 Nov 2019 11:08:12 GMT

Perhaps this?

Count(DISTINCT{$<BUILD_RESOURCES_SUB={"BUILD_RESOURCES_SUB<>PRIMARY_ASSIGNEE"}>}DEFECT_ID)

Count(If(BUILD_RESOURCES_SUB<>PRIMARY_ASSIGNEE, DEFECT_ID))

Re: Count when not Primary

cbaqir — Wed, 06 Nov 2019 14:52:22 GMT

This still isn't quite right.

A DEFECT_ID can have multiple people listed on BUILD_RESOURCES_SUB. I want to aggregate on the field of PRIMARY_ASSIGNEE field. If jdoe is one of the BUILD_RESOURCES_SUB on 4 tickets that he is NOT the PRIMARY_ASSIGNEE on, it should show as 4.

It's close but not quite...

I think the issue is that my chart is aggregating on the Primary Assignee dimension but I need to count the tickets where the user is a build resource but NOT the primary assignee.

Is this where I could use total?

Re: Count when not Primary

cbaqir — Wed, 06 Nov 2019 16:41:40 GMT

@Anil_Babu_Samineni Perhaps set analysis with an intersection?