topic Re: Rangesum Issue in QlikView

Rangesum Issue

michaelneck — Wed, 23 Mar 2022 12:40:32 GMT

Hi All,

I am having an issue with trying to get a Total Rangesum to work correctly. The below rangesum (column 4) is working as it should, but what I want to do in (column 5) is to take the sum (column4) of all the Tiers for the month and then in (column 6) to see the proportion of each tier. Please see below the table so far and then example tables of what the two other columns should look like and how they should calculate. I am using Qlikview 12. Any help would be appreciated..

Re: Rangesum Issue

Miguel_Angel_Baeyens — Tue, 29 Mar 2022 11:35:27 GMT

Check the use of TOTAL qualifier and filters:

https://help.qlik.com/en-US/qlikview/May2021/Subsystems/Client/Content/QV_QlikView/Examples%20of%20Aggregate%20Qualifiers.htm

Re: Rangesum Issue

michaelneck — Tue, 29 Mar 2022 23:07:41 GMT

Hi Miguel,

Thanks for the steer in the right direction, the following seems to work for a straight table If I sort by Tier

RangeSum(Above(Sum({<
Tier = {1,2,3,4,5}
>}[Euro_Equiv]), 0, 4))

RangeSum(Above(Sum({<
Tier = {1,2,3,4,5}
>}TOTAL <QuarterYear>[Euro_Equiv]), 0, 4))

Although when I convert it to a bar chart the sorting becomes an issue as the charts primary dimension is QuarterYear and not Tier. Do you know if there a way to overide that as seems to only sort on the 1st Dimension (QuarterYear)?

As a straight Table (working as should)

As a chart not working due to sort on Quarter Year as Primary Dimension

Any help would be appreciated!

Thanks

Re: Rangesum Issue

Todd66 — Thu, 31 Mar 2022 05:27:25 GMT

The RangeSum() function in QlikView 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.

One Cognizant