Qlik Community

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
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?