topic Re: Selection affects the chart with TOTAL Qualifier in QlikView

Selection affects the chart with TOTAL Qualifier

Jeys — Fri, 29 Jan 2021 10:45:30 GMT

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

Re: Selection affects the chart with TOTAL Qualifier

PradeepK — Fri, 29 Jan 2021 11:11:07 GMT

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.

Re: Selection affects the chart with TOTAL Qualifier

Jeys — Sat, 30 Jan 2021 04:51:00 GMT

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