topic Not getting added sum when selecting two financial year or any selection. in QlikView

Not getting added sum when selecting two financial year or any selection.

Wed, 25 Nov 2020 16:16:04 GMT

When I select two financial year am not getting the sum of both year total complaints or fbc complaints or in any of the box the sum is not coming, only the highest year value is coming. the expression used in total complaints is :

Sum({<Year={$(=Max(Year))},TRANDATE={'>=$(vStartDate)<=$(vMonthEndDate)'},Quarter=,HalfYearFin=,Month=,Day=>}CMP_CUSTOMER_CALL_COUNT)

where vStartDate is :=If (GetSelectedCount(Month)=0 And GetSelectedCount(Quarter)=0,MonthStart(Date(Max(Date))),Date(Min(Date)))

and vMonthEndDate is :=MonthEnd(max(Date))

the default view without any selection should shows current month data only in the 6 boxes, and when selected any particular financial year or Months the total for the selection should come in all the boxes. The box is a gauge and straight table selected in fast type change in the general tab of a chart.

Can anyone please help me in solving this. Please check the sample as attachment to get some idea.

Re: Not getting added sum when selecting two financial year or any selection.

jonathandienst — Tue, 02 Aug 2016 07:27:49 GMT

This part is selecting the latest/selected year:

Year = {$(=Max(Year))

Change to

Year = (">=$(=Max(Year) - 1) <=$(=Max(Year))")

Re: Not getting added sum when selecting two financial year or any selection.

Tue, 02 Aug 2016 08:57:48 GMT

With the above expression I am getting 0 as result.

Re: Not getting added sum when selecting two financial year or any selection.

Tue, 02 Aug 2016 09:07:04 GMT

Thank you Jonathan for your reply, but with the above expression am getting 0 as result.

Re: Not getting added sum when selecting two financial year or any selection.

jonathandienst — Tue, 02 Aug 2016 09:14:14 GMT

I suggest you upload a sample qvw containing some representative data.

Re: Not getting added sum when selecting two financial year or any selection.

Tue, 02 Aug 2016 09:14:27 GMT

Thanks for the reply Vineeth, but still after removing Year={$(=Max(Year))} when am selecting two financial year its showing value for the highest year only.