From Qlikview Help: Returns the sum of a range of 1 to N arguments. As opposed to the + operator, rangesum will treat all non-numeric values as 0.

Here are a few examples of how to use the Qlikview RangeSum function

**Example 1** – Let’s say you simply want to display the sum of several data points in a text box object. Add a Text Object, then go into the properties window and type in the following formula:

Formula:

1 2 3 |
=RangeSum(20,40,60,80) |

The resulting display in the Text Object will look like this:

**Note**: If you were to introduce a character value into the formula, the resulting value would remain unchanged, since RangeSum treats non-numeric values as zero. So the formula =RangeSum(20,40,middle,60,80) still results in a value of 200.

**Example 2** – Say you have a Table Box, which is filtered down to a specific time period and category. In this example, I have NFL Quarterbacks for Week 2 of the 2014 season:

This Table Box displays the number of touchdowns for each player (Passing, Rushing and Receiving). Now I’d like to display a Text Object that shows the overall total number of touchdowns by Quarterbacks in week 2 of the 2014 NFL season. in the Text Object, I added the following formula:

Formula:

1 2 3 |
='Total TD: ' & RangeSum(Sum(PassTD),Sum(RushTD),Sum(RecTD)) |

The resulting display in the Text Object will look like this:

*Conclusions*

As you can see, the Qlikview RangeSum function is handy when you are looking to add up the sum of different data values or formula results. An advantage that RangeSum has over simply adding values together using the + sign is the treatment of non-numeric values. If you encounter a character in the Sum formula, the RangeSum function will treat the character as a 0 and complete the calculation.

*Additional Content*

*Additional Content*

Check out more examples by visiting my Home Page

Here you will find topics covering Qlikview SQL Server Excel VBA