Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
spugalen
Contributor
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)
  • SaaS

1 Reply
sunny_talwar

Would you be able to share a sample where we can see this issue?