topic Set Analysis - Function required to calculate Sales by Sales Invoice in App Development https://community.qlik.com/t5/App-Development/Set-Analysis-Function-required-to-calculate-Sales-by-Sales/m-p/2126263#M91659 <P>I have the below Sales Table:</P> <P>&nbsp;</P> <P>Invoice No&nbsp; Item No&nbsp; &nbsp;Sales Amount</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;45</P> <P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22</P> <P>&nbsp;</P> <P>I need a Set Analysis function to get Sales by Sales Invoice No. I basically first need to find sales by Invoice and then segregate the sales by buckets. 1-10, 10-20 and so on.</P> <P>&nbsp;</P> <P>I need the below result:</P> <P>75</P> <P>22</P> <P>&nbsp;</P> Sat, 07 Oct 2023 10:17:27 GMT m_adnan_ansari 2023-10-07T10:17:27Z Set Analysis - Function required to calculate Sales by Sales Invoice https://community.qlik.com/t5/App-Development/Set-Analysis-Function-required-to-calculate-Sales-by-Sales/m-p/2126263#M91659 <P>I have the below Sales Table:</P> <P>&nbsp;</P> <P>Invoice No&nbsp; Item No&nbsp; &nbsp;Sales Amount</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;25</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;101&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P> <P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;45</P> <P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 23&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;22</P> <P>&nbsp;</P> <P>I need a Set Analysis function to get Sales by Sales Invoice No. I basically first need to find sales by Invoice and then segregate the sales by buckets. 1-10, 10-20 and so on.</P> <P>&nbsp;</P> <P>I need the below result:</P> <P>75</P> <P>22</P> <P>&nbsp;</P> Sat, 07 Oct 2023 10:17:27 GMT https://community.qlik.com/t5/App-Development/Set-Analysis-Function-required-to-calculate-Sales-by-Sales/m-p/2126263#M91659 m_adnan_ansari 2023-10-07T10:17:27Z