how to add and exclude row data in qlikview

[Anonymous]

my source like below..

How to get cont MeetingA and Meeting B

client	meetingcount	meetingtype
ddd	5	MeetingA
ddd	6	MeetingB
ddd	7	MeetingC
sss	8	MeetingA
sss	9	MeetingB
sss	10	MeetingC
aaa	11	MeetingA
aaa	12	MeetingB
aaa	13	MeetingC

i am excepted o/p is

client  meetingtype        meetingcount       total

aaa  MeetingA                           11                   24

aaa MeetingB                              12                 27

aaa MeetingC                              13                 13

ddd MeetingA                               5                     24

ddd MeetingB                               6                    27

ddd MeetingC                             7                      7

sss MeetingA                                8                         24

sss MeetingB                                   9                      27

sss MeetingC                              10                        10

[Anil_Babu_Samineni]

Perhaps this?

Sum(TOTAL <meetingtype> meetingcount)

[Anonymous]

Hi Anil,

Weneed only count in Meeting A,Meeting B.

Thanks,

[sunny_talwar]

May be this

If(Match(meetingtype, 'Meeting A', 'Meeting B'), Sum(TOTAL <meetingtype> meetingcount), Sum(meetingcount))

[Anil_Babu_Samineni]

Like this?

Sum(TOTAL <meetingtype> {<meetingtype={'MeetingA','MeetingB'}>} meetingcount)

[susovan]

Hi,

It should be work,

PFA

[sunny_talwar]

This is a good way also and you can add this to the above expression (without needing to use an if statement)

Sum(TOTAL <meetingtype> {<meetingtype = {'MeetingA','MeetingB'}>} meetingcount) +

Sum({<meetingtype -= {'MeetingA','MeetingB'}>} meetingcount)

[Anonymous]

hi anil ,

After using ur expression only count Meeting,Metting B is commng Meeting C is gone.

I am expacted  o/p  MeetingA and Meeting B count and Meeting C asusal data.

Thanks,

[sunny_talwar]

Did you try one of these?

If(Match(meetingtype, 'Meeting A', 'Meeting B'), Sum(TOTAL <meetingtype> meetingcount), Sum(meetingcount))

Sum(TOTAL <meetingtype> {<meetingtype = {'MeetingA','MeetingB'}>} meetingcount) +

Sum({<meetingtype -= {'MeetingA','MeetingB'}>} meetingcount)

[Anonymous]

Hi

I am

i am excepted o/p is like this (Not for all sum )

client  meetingtype        meetingcount       total

aaa  MeetingA                           11                   24

aaa MeetingB                             12                 27

aaa MeetingC                             13                 13

ddd MeetingA                               5                     24

ddd MeetingB                              6                    27

ddd MeetingC                            7                        7

sss MeetingA                               8                       24

sss MeetingB                                9                    27

sss MeetingC                              10                       10