Cumulative rangesum with respect to a field in Qliksense

[SunainaUmberkar]

Hello All,

This is wrt to the previous post which i had posted for cumulative rangesum with respect to timestamp.

In this scenario, i need to cumulate values based on GroupName. The hierarchy is same Timestamp, ServerName,Licname, GroupName, Capacity. For each timestamp, each server, each license  we have different groups. So when a selection criteria is applied till License level, it should cumulate based on different groups. If there is a selection made at Serverlevel, cumulation will be done altogether irrespective of groupname or licname.

I tried to use below expression in table,

RangeSum(Above(TOTAL Sum(distinct Capacity), 0, Aggr(RowNo(TOTAL),
GroupName ,Capacity)))

This works fine for some scenrio, for some it is not.

I have attached an excel with this scenario. Can anyone please help.

[SunainaUmberkar]

Hello Everyone,

Can anyone please help me with this scenario.

Thanks.

[SunainaUmberkar · Accepted solution]

Hello Everyone,

I have achieved this using below expression in front end.

max(aggr(RangeSum(Above(TOTAL Aggr(Sum(distinct Capacity ), ServerName,LicName), 0, RowNo(TOTAL))),ServerName,LicName))