Qlik Community

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:

 

SupervisorMembersum(Count)
280
GOA10
GOB20
GOD30
GOE70

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

PFA qvw for Reference

Thanks in Advance

1 Solution

Accepted Solutions
MVP
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
MVP

Re: Member name equals closed by Name

May be this

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

MVP
MVP

Re: Member name equals closed by Name

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)

Capture.PNG

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
MVP

Re: Member name equals closed by Name

This

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

or

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

Re: Member name equals closed by Name

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

Not applicable

Re: Member name equals closed by Name

Thanks a lot

Community Browser