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..
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
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.