# App Development

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save \$400 before Dec 31st: REGISTER NOW!
cancel
Showing results for
Did you mean:
Contributor

## ABC Analysis with multiple condition

Here is the formula which I am using to create a list box/calculated dimension in filter pane that allows multiple select .  The formula is not giving the desired results . It should list all the segments as per the condition in the formula . It is currently listing only the first condition result(0-10% in the filter pane). Can you help me here ?

=Aggr(

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.1, '0-10%',

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.2, '10-20%',

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.3, '20-30%',

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.4, '30-40%',

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.5, '40-50%',

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.6, '50-60%',

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.7, '60-70%',

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.8, '70-80%',

If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/

(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.9, '80-90%','Above 90 %'

))))))))),

(Region,Country,State,Market,[Stay Week])

)

Labels (1)