# QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

## Member name equals closed by Name

Hi All,

I want to show sum of only those member whose name is equal to closed by name.

Expected Output:

 Supervisor Member sum(Count) 280 GO A 10 GO B 20 GO D 30 GO E 70

Note: we can't make any changes to the script

PFA qvw for Reference

1 Solution

Accepted Solutions
MVP

## Re: Member name equals closed by Name

This

Sum({<Supervisor= {'GO'}>} If(Member = [Colsed By], Count))

or

Sum({<Flag = {1}, Supervisor= {'GO'}>} Count)

7 Replies
MVP

## Re: Member name equals closed by Name

May be this

Sum(If(Member = [Colsed By], Count))

MVP

## Re: Member name equals closed by Name

or create a flag

If(Member = [Colsed By], 1, 0) as Flag;

Supervisor, Member, Colsed By, Count

GO, A, A, 10

GO, B, B, 20

GO, D, D, 30

GO, D, B, 40

GO, E, G, 50

GO, E, F, 60

GO, E, E, 70

];

and use this expression

Sum({<Flag = {1}>} Count)

Not applicable

## Re: Member name equals closed by Name

Thanks for the Quick reply but i also have some Set analysis written in the expression and i cant make any changes in the Script

Not applicable

## Re: Member name equals closed by Name

Thanks for the Quick reply but i also have some Set analysis written in the expression .

like

Sum({<Supervisor= {'GO'}>}Count)

MVP

## Re: Member name equals closed by Name

This

Sum({<Supervisor= {'GO'}>} If(Member = [Colsed By], Count))

or

Sum({<Flag = {1}, Supervisor= {'GO'}>} Count)

MVP

## Re: Member name equals closed by Name

How you are expecting 280 for Total Sum?? Is that is type error

Not applicable

Thanks a lot