topic Re: Cumm Sales Calculation in QlikView

Cumm Sales Calculation

arethaking — Wed, 25 Nov 2020 16:16:04 GMT

Hi All,

I want show Sales values as below:

JAN Sales=JAN Sales

FEB Sales=JAN Sales + FEB Sales

MAR Sales=JAN Sales + FEB Sales +MAR Sales

DEC Sales=JAN Sales + FEB Sales +MAR Sales+....+ DEC Sales.

By Default, want to show the data untill current month.

Please help me.

Re: Cumm Sales Calculation

trdandamudi — Wed, 14 Sep 2016 06:24:59 GMT

In the chart select "Full Accumulation" as shown in the screen shot below:

Re: Cumm Sales Calculation

arethaking — Wed, 14 Sep 2016 06:36:01 GMT

If I select Full Accumulation,

If there is no value for the month, it is showing previous month Sales.

I want to show until SEP.

Re: Cumm Sales Calculation

Anil_Babu_Samineni — Wed, 14 Sep 2016 06:36:51 GMT

Like This

Re: Cumm Sales Calculation

saimahasan — Wed, 14 Sep 2016 06:38:42 GMT

You can either use the "Full Accumulation" option or else you can use Rangesum and above functions as shown below:

=RangeSum(Above(Range),Sum([Total Amount]))

Re: Cumm Sales Calculation

HirisH_V7 — Wed, 14 Sep 2016 07:09:15 GMT

Hi,

Check is this your'e looking for,

By using this expressions and UN-checking full accumulation at both expressions,

IF(Sum({<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"}, Month, Year>}Sales),
Rangesum(Sum({<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"}, Month, Year>}Sales),Above("Sales1")))

If(Sum({<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"}, Month, Year>}Sales2),
Rangesum(Sum({<Date = {"$(='>=' & Date(YearStart(Max(Date)), 'DD/MM/YYYY') & '<=' & Date(Max(Date), 'DD/MM/YYYY'))"}, Month, Year>}Sales2),Above("Sales 2")))

HTH,

PFA,

Hirish

Re: Cumm Sales Calculation

sasikanth — Wed, 14 Sep 2016 07:25:23 GMT

Use below expressions

Exp1 : Sales :

Sum(Sales)

Exp 2: Accumulatedsales:

If(sum(Sales)<>0, sum( aggr( rangesum( above(Sum(Sales),0,12) ),MonthYear)))

Re: Cumm Sales Calculation

MK_QSL — Wed, 14 Sep 2016 07:59:30 GMT

Here you go !