Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Save $650 on Qlik Connect, Dec 1 - 7, our lowest price of the year. Register with code CYBERWEEK: Register
cancel
Showing results for 
Search instead for 
Did you mean: 
michael_maeuser
Partner Ambassador
Partner Ambassador

Help with calculated listbox

Hi, I have a listbox with this formula:

aggr(
if(
RangeSum(Above(
sum(if(Date=Today(), Lagerwert))/
sum(total if(Date=Today(), Lagerwert)),0,500))
<=$(ABC A),'A',
if(
RangeSum(Above(
sum(if(Date=Today(), Lagerwert))/
sum(total if(Date=Today(), Lagerwert)),0,500))
<=$(ABC B),'B',
if(
RangeSum(Above(
sum(if(Date=Today(), Lagerwert))/
sum(total if(Date=Today(), Lagerwert)),0,500))
>$(ABC B)
,'C')))
,Product)

So in the listbox appears A, B, C. Now I need to tell QV, that it starts cumulating (rangesum) with the product having the highest value out of sum(Lagerwert). It´s a ABC-Analysis and this is the way the table chart is and must be sorted. I hope this is makeable. Thanks in advance! Michael
0 Replies