Qlikview RangeSum

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:

Qlikview RangeSum

Formula:

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

Qlikview RangeSum

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:

Qlikview RangeSum

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:

Qlikview RangeSum

Formula:

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

Qlikview RangeSum

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

Check out more examples by visiting my Home Page

Here you will find topics covering  Qlikview  SQL Server  Excel VBA

 

Leave a Comment