topic Re: Defect Created by and Closed by count for Each Member in QlikView

Defect Created by and Closed by count for Each Member

Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

i have a straight table in which Dimension is Member

and i want to show the number of defects created by and number of defects closed by each member in that table

PFA files for reference.

Re: Defect Created by and Closed by count for Each Member

sunny_talwar — Fri, 19 May 2017 13:52:29 GMT

This is what you need?

Re: Defect Created by and Closed by count for Each Member

Mon, 22 May 2017 07:25:36 GMT

Hi the output is correct but i cant make any changes to the script i want to perform it on the frond end itself.

Thanks

Re: Defect Created by and Closed by count for Each Member

Kushal_Chawda — Mon, 22 May 2017 07:33:03 GMT

may be

Dimension:

Member

Expression:

1) Created by

Count({<Member=p([Created By])>}[Defect ID])

2) Closed by

Count({<Member=p(Closed by)>}[Defect ID])

Link both your table on Defect ID

Re: Defect Created by and Closed by count for Each Member

Mon, 22 May 2017 11:31:13 GMT

In the above case if i select a member in the list box it is giving me 2 rows instead it should give me a single row for which i have selected in member.

Thanks