topic Aggr and Sum for Bands in QlikView https://community.qlik.com/t5/QlikView/Aggr-and-Sum-for-Bands/m-p/74751#M779036 <HTML><HEAD></HEAD><BODY><P>Here is my data :</P><P>Below is the aggregation of Gross pos by quarter , this for all the Products ,</P><P>I need to create&nbsp; Bands based of Gross POS aggregated by each Product , so is the Gross POS for the Product is 3000$ it should fall under band"$1-$5000" so on ...</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 268px;"><TBODY><TR><TD class="xl63" height="20" width="96">YearQuarter</TD><TD class="xl64" width="172">Gross POS</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;"></TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">2018Q4</TD><TD class="xl65" style="border-top: none; border-left: none;">($11,192,392.54)</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">2019Q1</TD><TD class="xl65" style="border-top: none; border-left: none;"><P>($4,053,867.10)</P></TD></TR></TBODY></TABLE><P></P><P>Expected Output :</P><P></P><P>Product Discount Band&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018Q4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2019Q1</P><P></P><P>1-5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.54M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $4000000M</P><P>5001-10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $192.392M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $53867.10M</P><P>10001-20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $11.00M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>20001-50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>50001-100000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P></P><P>Any help on how i can achieve this?Attached app</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT stevejones1 2020-11-25T16:16:04Z Aggr and Sum for Bands https://community.qlik.com/t5/QlikView/Aggr-and-Sum-for-Bands/m-p/74751#M779036 <HTML><HEAD></HEAD><BODY><P>Here is my data :</P><P>Below is the aggregation of Gross pos by quarter , this for all the Products ,</P><P>I need to create&nbsp; Bands based of Gross POS aggregated by each Product , so is the Gross POS for the Product is 3000$ it should fall under band"$1-$5000" so on ...</P><P></P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 268px;"><TBODY><TR><TD class="xl63" height="20" width="96">YearQuarter</TD><TD class="xl64" width="172">Gross POS</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;"></TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">2018Q4</TD><TD class="xl65" style="border-top: none; border-left: none;">($11,192,392.54)</TD></TR><TR><TD class="xl64" height="20" style="border-top: none;">2019Q1</TD><TD class="xl65" style="border-top: none; border-left: none;"><P>($4,053,867.10)</P></TD></TR></TBODY></TABLE><P></P><P>Expected Output :</P><P></P><P>Product Discount Band&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2018Q4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 2019Q1</P><P></P><P>1-5000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.54M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $4000000M</P><P>5001-10000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $192.392M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $53867.10M</P><P>10001-20000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $11.00M&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>20001-50000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P>50001-100000&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; $0.00&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0</P><P></P><P></P><P>Any help on how i can achieve this?Attached app</P><P></P><P>Thanks</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggr-and-Sum-for-Bands/m-p/74751#M779036 stevejones1 2020-11-25T16:16:04Z Re: Aggr and Sum for Bands https://community.qlik.com/t5/QlikView/Aggr-and-Sum-for-Bands/m-p/74752#M779037 <HTML><HEAD></HEAD><BODY><P>Please try with calculated dimension.</P><P></P><P>Attach reduced app plz</P></BODY></HTML> Sun, 08 Apr 2018 02:34:13 GMT https://community.qlik.com/t5/QlikView/Aggr-and-Sum-for-Bands/m-p/74752#M779037 shiveshsingh 2018-04-08T02:34:13Z Re: Aggr and Sum for Bands https://community.qlik.com/t5/QlikView/Aggr-and-Sum-for-Bands/m-p/74753#M779038 <HTML><HEAD></HEAD><BODY><P>Try this.....</P><P></P><P>Load *, IF(Salary&lt;=5000, '0-5000',</P><P>IF(Salary&gt;5000 and Salary&lt;=10000, '5001-10000',</P><P>IF(Salary&gt;10000 and Salary&lt;=20000, '10001-20000',</P><P>IF(Salary&gt;20000 and Salary&lt;=50000, '20001-50000',</P><P>IF(Salary&gt;50000 and Salary&lt;=100000, '50001-100000'))))) as SalaryBand;</P><P></P><P>Please try to attach small application...</P></BODY></HTML> Sun, 08 Apr 2018 17:29:46 GMT https://community.qlik.com/t5/QlikView/Aggr-and-Sum-for-Bands/m-p/74753#M779038 Nagaraju_KCS 2018-04-08T17:29:46Z