Qlik Community

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
Jeys
Partner
Partner

Selection affects the chart with TOTAL Qualifier

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 

2 Replies
PradeepK
Creator II
Creator II

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
Partner
Partner
Author

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