How to make a Daily Accumulated Sales in Qlikview Pivot table

[#1]

Hi all,

I am new to Qlikview and not so familiar with the QV functions. May I know if it's possible to create a pivot table report which can auto-accumulate the sales data by date?

I tried this expression =rangesum(sum(Sales),above(Sum(Sales))), but the only thing i can get is the accumulative sum of previous one hour but no the accumulative sum of all previous hours.

May I get any of your assist?

Attached is the data source, qvw and my expected result.

Thank you very much.

[antoniotiman]

Hi Katherine,

try this

RangeSum(Above(TOTAL Sum(Sales),0,RowNo(TOTAL)))

Regards,

Antonio

[sunny_talwar]

If you need accumulation for each shop... you can try this

=Aggr(RangeSum(Above(Sum(Sales), 0, RowNo())), Shop, DateTime)

Where DateTime is created in the script like this

Table:

LOAD Shop,

    Date,

    Time,

    Sales

FROM

[Data Source.xlsx]

(ooxml, embedded labels, table is Sheet1);

FinalTable:

LOAD *,

Date+Time as DateTime

Resident Table

Order By Date, Time;

DROP Table Table;

[antoniotiman · Accepted solution]

I haven't seen Result.png

RangeSum(Above(TOTAL Sum(Sales),0,RowNo()))

Regards,

Antonio

[#5]

Thank you very much for all the help!

That's very helpful.

Regards,

Katherine