topic Re: ABC Analysis with multiple condition in App Development

topic Re: ABC Analysis with multiple condition in App Development https://community.qlik.com/t5/App-Development/ABC-Analysis-with-multiple-condition/m-p/1703890#M53945 <P>Would you be able to share a sample where we can see this issue?</P> Wed, 20 May 2020 14:36:06 GMT sunny_talwar 2020-05-20T14:36:06Z ABC Analysis with multiple condition https://community.qlik.com/t5/App-Development/ABC-Analysis-with-multiple-condition/m-p/1703579#M53894 <P>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 ?</P><P> </P><P>=Aggr(</P><P>    If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.1, '0-10%',</P><P> </P><P> If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.2, '10-20%',</P><P> </P><P> If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.3, '20-30%',</P><P> </P><P> If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.4, '30-40%',</P><P> </P><P> If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.5, '40-50%',</P><P> </P><P> If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.6, '50-60%',</P><P> </P><P> If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.7, '60-70%',</P><P> </P><P> If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.8, '70-80%',</P><P> </P><P> If(Rangesum(Above(((Sum([Demand Data.CY Total RNs])/Sum([Demand Data.Capacity]))-</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])))/</P><P>(Sum([CYPW Total RNs])/Sum([Demand Data.Capacity])),1,RowNo()))<0.9, '80-90%','Above 90 %'</P><P> </P><P>))))))))),</P><P>    (Region,Country,State,Market,[Stay Week])</P><P>    )</P> Thu, 01 Apr 2021 13:46:08 GMT https://community.qlik.com/t5/App-Development/ABC-Analysis-with-multiple-condition/m-p/1703579#M53894 spugalen 2021-04-01T13:46:08Z Re: ABC Analysis with multiple condition https://community.qlik.com/t5/App-Development/ABC-Analysis-with-multiple-condition/m-p/1703890#M53945 <P>Would you be able to share a sample where we can see this issue?</P> Wed, 20 May 2020 14:36:06 GMT https://community.qlik.com/t5/App-Development/ABC-Analysis-with-multiple-condition/m-p/1703890#M53945 sunny_talwar 2020-05-20T14:36:06Z