topic Aggregate based on dimensions in QlikView https://community.qlik.com/t5/QlikView/Aggregate-based-on-dimensions/m-p/1379548#M810862 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Is there an way to sum based on dimension.</P><P></P><P>For example (Data Source):</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 618px;"><TBODY><TR><TD class="xl63" height="20" width="132">Date</TD><TD class="xl63" style="border-left: none;" width="91">Employee</TD><TD class="xl63" style="border-left: none;" width="175">PurchaseOrder</TD><TD class="xl63" style="border-left: none;" width="156">Vendor</TD><TD class="xl63" style="border-left: none;" width="64">Days</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl63" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl63" style="border-top: none; border-left: none;">P0001</TD><TD class="xl63" style="border-top: none; border-left: none;">V0001</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl63" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl63" style="border-top: none; border-left: none;">P0002</TD><TD class="xl63" style="border-top: none; border-left: none;">V0001</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl63" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl63" style="border-top: none; border-left: none;">P0002</TD><TD class="xl63" style="border-top: none; border-left: none;">V0002</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P>If it vendor,date and employee is same then the days count is 1 in my output</P><P></P><P>Expected Output:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 624px;"><TBODY><TR><TD class="xl67" height="20" width="132">Date</TD><TD class="xl65" style="border-left: none;" width="91">Employee</TD><TD class="xl65" style="border-left: none;" width="175">PurchaseOrder</TD><TD class="xl65" style="border-left: none;" width="156">Vendor</TD><TD class="xl65" style="border-left: none;" width="70">Total Days</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl65" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl65" style="border-top: none; border-left: none;">P0001</TD><TD class="xl65" style="border-top: none; border-left: none;">V0001</TD><TD class="xl67" rowspan="2" style="border-top: none;">1</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl65" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl65" style="border-top: none; border-left: none;">P0002</TD><TD class="xl65" style="border-top: none; border-left: none;">V0001</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl65" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl65" style="border-top: none; border-left: none;">P0002</TD><TD class="xl65" style="border-top: none; border-left: none;">V0002</TD><TD class="xl67" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P>Selva</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT selvakumarsr 2020-11-25T16:16:04Z Aggregate based on dimensions https://community.qlik.com/t5/QlikView/Aggregate-based-on-dimensions/m-p/1379548#M810862 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>Is there an way to sum based on dimension.</P><P></P><P>For example (Data Source):</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 618px;"><TBODY><TR><TD class="xl63" height="20" width="132">Date</TD><TD class="xl63" style="border-left: none;" width="91">Employee</TD><TD class="xl63" style="border-left: none;" width="175">PurchaseOrder</TD><TD class="xl63" style="border-left: none;" width="156">Vendor</TD><TD class="xl63" style="border-left: none;" width="64">Days</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl63" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl63" style="border-top: none; border-left: none;">P0001</TD><TD class="xl63" style="border-top: none; border-left: none;">V0001</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl63" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl63" style="border-top: none; border-left: none;">P0002</TD><TD class="xl63" style="border-top: none; border-left: none;">V0001</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD></TR><TR><TD align="right" class="xl64" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl63" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl63" style="border-top: none; border-left: none;">P0002</TD><TD class="xl63" style="border-top: none; border-left: none;">V0002</TD><TD align="right" class="xl63" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P>If it vendor,date and employee is same then the days count is 1 in my output</P><P></P><P>Expected Output:</P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><P>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 624px;"><TBODY><TR><TD class="xl67" height="20" width="132">Date</TD><TD class="xl65" style="border-left: none;" width="91">Employee</TD><TD class="xl65" style="border-left: none;" width="175">PurchaseOrder</TD><TD class="xl65" style="border-left: none;" width="156">Vendor</TD><TD class="xl65" style="border-left: none;" width="70">Total Days</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl65" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl65" style="border-top: none; border-left: none;">P0001</TD><TD class="xl65" style="border-top: none; border-left: none;">V0001</TD><TD class="xl67" rowspan="2" style="border-top: none;">1</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl65" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl65" style="border-top: none; border-left: none;">P0002</TD><TD class="xl65" style="border-top: none; border-left: none;">V0001</TD></TR><TR><TD align="right" class="xl66" height="20" style="border-top: none;">1-Jan-17</TD><TD class="xl65" style="border-top: none; border-left: none;">Emp1</TD><TD class="xl65" style="border-top: none; border-left: none;">P0002</TD><TD class="xl65" style="border-top: none; border-left: none;">V0002</TD><TD class="xl67" style="border-top: none; border-left: none;">1</TD></TR></TBODY></TABLE><P></P><P>Thanks,</P><P>Selva</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Aggregate-based-on-dimensions/m-p/1379548#M810862 selvakumarsr 2020-11-25T16:16:04Z Re: Aggregate based on dimensions https://community.qlik.com/t5/QlikView/Aggregate-based-on-dimensions/m-p/1379549#M810863 <HTML><HEAD></HEAD><BODY><P>May be this:<STRONG><BR /></STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG>Aggr(Count(DISTINCT Date&amp;Vendor&amp;Employee), Date, Vendor, Employee)</STRONG></P><P><STRONG><BR /></STRONG></P><P><STRONG><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/178286_Capture.PNG" style="height: auto;" /><BR /></STRONG></P></BODY></HTML> Mon, 02 Oct 2017 11:34:29 GMT https://community.qlik.com/t5/QlikView/Aggregate-based-on-dimensions/m-p/1379549#M810863 sunny_talwar 2017-10-02T11:34:29Z