topic Re: Member name equals closed by Name in QlikView

Member name equals closed by Name

Tue, 23 May 2017 14:57:50 GMT

Hi All,

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

Expected Output:

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

PFA qvw for Reference

Thanks in Advance

sunny_talwar — Tue, 23 May 2017 15:00:10 GMT

May be this

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

sunny_talwar — Tue, 23 May 2017 15:02:13 GMT

or create a flag

LOAD *,

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

LOAD * INLINE [

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)

Tue, 23 May 2017 15:09:41 GMT

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

Tue, 23 May 2017 15:10:35 GMT

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

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

sunny_talwar — Tue, 23 May 2017 15:11:39 GMT

This

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

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

Anil_Babu_Samineni — Tue, 23 May 2017 15:13:10 GMT

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

Tue, 23 May 2017 15:17:26 GMT

Thanks a lot