
Re: Dynamic Pareto / ABC (with a twist)
Sunny Talwar Feb 26, 2018 11:54 AM (in response to Jens Kuelpmann)Try this
Aggr(
If(RangeSum(Above(Sum(Meas1), 0, RowNo())) / Sum(TOTAL Meas1) <= 0.8, 'A',
If(RangeSum(Above(Sum(Meas1), 0, RowNo())) / Sum(TOTAL Meas1) <= 0.95, 'B', 'C'))
, (Dim1, (=Sum(Meas1), DESC)))

Re: Dynamic Pareto / ABC (with a twist)
Jens Kuelpmann Feb 27, 2018 5:19 AM (in response to Jens Kuelpmann)Thanks  sadly this does not change the outcome, Dim1 still sorted by load order.

Re: Dynamic Pareto / ABC (with a twist)
Sunny Talwar Feb 27, 2018 12:31 PM (in response to Jens Kuelpmann)Might help to see a sample if you can share one?


Re: Dynamic Pareto / ABC (with a twist)
Jens Kuelpmann Feb 27, 2018 11:40 AM (in response to Jens Kuelpmann)Okay, apparently Sense is quite picky about how you actually construct the formula, it just does not say so in the editor.
This  finally  worked:
=Aggr(
If(RangeSum(Above(Sum(Meas1) / Sum(TOTAL Meas1), 1, RowNo())) <= 0.8, 'A',
If(RangeSum(Above(Sum(Meas1) / Sum(TOTAL Meas1), 1, RowNo())) <= 0.95, 'B',
'C')), (Dim1,(=Sum(Meas1), Desc)))
Moved the Sum(TOTAL ... ) into the Above() function and added exactly the right amount of parentheses in exactly the right places in the StructuredParameter. Why Sense does not complain when you write something that does not comply with the definition of a StructuredParameter I have no idea. Would have made things easier for me.

Re: Dynamic Pareto / ABC (with a twist)
Pablo Labbe Feb 27, 2018 2:26 PM (in response to Jens Kuelpmann)When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others