Selection affects the chart with TOTAL Qualifier

[Jeys]

Hi all,

Please help me in the following scenario.

I have a chart which has two dimensions MonthYr and Channel. One of the channel A is subset of another channel B.  That means is if I have a transaction T1 coming through Channel A will always pass through Channel B before it completes. So in the chart I should have these Transactions counted once only in Channel A and not twice in channel B.

I have used the below code:

=if(match(Channel,'B'),
        count(total<MonthYr> distinct {<Channel={'B'}
         ,%Date={"<=$(=vMaxDate)>=$(=vPrev6month)"}
         ,MonthYr
  >}Cases)
   - count(total<MonthYr> distinct {< Channel={'A'}
     ,%Date={"<=$(=vMaxDate)>=$(=vPrev6month)"}
     ,MonthYr
  >}Cases)
,count(distinct {< %Date={"<=$(=vMaxDate)>=$(=vPrev6month)"}
         ,MonthYr
  >}Cases)
)

 Now the problem is it is working fine with no selection in the MonthYr field. Once a selection is made I dont have the count of cases as Channel B - Channel A except for the month selected. Please help me in correcting the code 

[PradeepK]

I think there is some confusion.. 

TOTAL qualifier is used for defining aggregation scope.. i.e dimensions used in parent Viz.

It's not related to selection scope.. Look into Set Identifiers (1,$) or Set Modifier options.

[Jeys]

I’m aware that Total qualifier is used for aggregation but the problem is the aggregation gets working fine for the current selected month and the other months are showing the non aggregate value