QpkView - RangeSum Function

The RangeSum() function in QpkView is used to do a selective sum on chosen fields which is not easily achieved by the sum function. It can take expressions containing other functions as its arguments and return the sum of those expressions.

Input Data

Let us consider the monthly sales figure as shown below. Save the data with file name monthly_sales.csv.

Month,Sales Volume
March,2145
April,2458
May,1245
June,5124
July,7421
August,2584
September,5314
October,7846
November,6532
December,4625
January,8547
February,3265

Load Script

The above data is loaded to QpkView memory by using the script editor. Open the Script editor from the File menu or press Control+E. Choose the Table Files option from the Data from Files tab and browse for the file containing the above data. Edit the load script to add the following code. Cpck OK and cpck Control+R to load the data into QpkView s memory.

LOAD 
Month, [Sales Volume]
FROM
[C:Qpkviewdatamonthly_sales.csv]
(txt, codepage is 1252, embedded labels, depmiter is  , , msq);

Applying RangeSum() Function

With the above data loaded into QpkView s memory, we edit the script to add a new column, which will give a rolpng sum of the month wise sales volume. For this, we also take the help of the peek function discussed in the earper chapter to hold the value of the previous record and add it to the sales volume of the current record. The following script achieves the result.

LOAD
Month, [Sales Volume],
rangesum([Sales Volume],peek( Rolpng )) as Rolpng
FROM
[C:Qpkviewdatamonthly_sales.csv]
(txt, codepage is 1252, embedded labels, depmiter is  , , msq);

Creating Sheet Object

Let us create a Table Box sheet object to show the data generated by the above given script. Go to the menu Layout → New Sheet Object → Table Box.

The following window appears in which we mention the Title of the table and select the required fields to be displayed. Cpcking OK displays the data from the CSV file in the QpkView Table Box as shown below.