topic Re: Sum of Distinct Records in QlikView https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847639#M531251 <HTML><HEAD></HEAD><BODY><P>Test and confirm</P></BODY></HTML> Mon, 08 Jun 2015 12:44:04 GMT Anonymous 2015-06-08T12:44:04Z Sum of Distinct Records https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847637#M531249 <HTML><HEAD></HEAD><BODY><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Hi</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Below is the sample data</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&nbsp;&nbsp; </P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">&nbsp;&nbsp; </P><TABLE border="0" cellpadding="0" cellspacing="0" style="border: 0px; font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"><TBODY style="font-weight: inherit; font-style: inherit; font-family: inherit;"><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl65" height="17" style="padding-right: 4px; padding-left: 4px; border: 0px solid black; font-style: inherit; font-family: inherit;" width="199">Date</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="182">MAR</TD><TD class="xl65" style="padding-right: 4px; padding-left: 4px; border-style: solid solid solid none; border-top-color: black; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;" width="98">&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; vTAT</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl66" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2015-04-24</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">150424SCBLAU2SAXXX4495866032</TD><TD align="right" class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">1:13:41</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl66" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2015-04-24</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">150424SCBLAU2SBXXX0123004002</TD><TD align="right" class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">63:41:27</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl66" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2015-04-24</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">150424SCBLAU2SAXXX4495866033</TD><TD align="right" class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">65:52:23</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl66" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2015-04-24</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">150424SCBLAU2SBXXX0123004002</TD><TD align="right" class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">63:41:27</TD></TR><TR style="border: 0px; font-weight: inherit; font-style: inherit; font-family: inherit;"><TD class="xl66" height="17" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid; border-right-color: black; border-bottom-color: black; border-left-color: black; font-style: inherit; font-family: inherit;">2015-04-24</TD><TD class="xl66" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;">150424SCBLAU2SBXXX0123004002</TD><TD align="right" class="xl67" style="padding-right: 4px; padding-left: 4px; border-style: none solid solid none; border-right-color: black; border-bottom-color: black; font-style: inherit; font-family: inherit;"><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">63:41:27</P></TD></TR></TBODY></TABLE><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Need to find the average of vTAT for DISTINCT MAR using Date as Dimension</P><P></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Average should be around 43:35:50</P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;"></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">It should be displayed as a BAR CHART</P><P></P><P></P><P style="font-size: 12px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d; background-color: #f2f2f2;">Regards</P></BODY></HTML> Mon, 08 Jun 2015 12:38:24 GMT https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847637#M531249 2015-06-08T12:38:24Z Re: Sum of Distinct Records https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847638#M531250 <HTML><HEAD></HEAD><BODY><P>May be this:</P><P></P><P><STRONG>=Avg(Aggr(Avg(vTAT), MAR))</STRONG></P></BODY></HTML> Mon, 08 Jun 2015 12:43:13 GMT https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847638#M531250 sunny_talwar 2015-06-08T12:43:13Z Re: Sum of Distinct Records https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847639#M531251 <HTML><HEAD></HEAD><BODY><P>Test and confirm</P></BODY></HTML> Mon, 08 Jun 2015 12:44:04 GMT https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847639#M531251 Anonymous 2015-06-08T12:44:04Z Re: Sum of Distinct Records https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847640#M531252 <HTML><HEAD></HEAD><BODY><P>Please find attached a sample application with the desired output:</P><P></P><P><IMG __jive_id="88673" alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/88673_Capture.PNG" style="height: auto;" /></P><P><IMG alt="Capture.PNG" class="jive-image image-2" src="https://community.qlik.com/legacyfs/online/88674_Capture.PNG" style="height: auto;" /></P></BODY></HTML> Mon, 08 Jun 2015 12:47:55 GMT https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847640#M531252 sunny_talwar 2015-06-08T12:47:55Z Re: Sum of Distinct Records https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847641#M531253 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Hi </P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Below is my Requirement</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Dimension - &gt; Date</P><P style="font-size: 13.3333330154419px;">Need to find the average of Time Diff between EndDate and Start Date for Distinct MAR</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">In the Attached file the average should be 45:35:50</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Note: Source file attached as excel in <A href="https://community.qlik.com/thread/167431">Distinct Sum</A></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Regards,</P><P style="font-size: 13.3333330154419px;">Senthil</P></BODY></HTML> Mon, 08 Jun 2015 13:08:24 GMT https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847641#M531253 2015-06-08T13:08:24Z Re: Sum of Distinct Records https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847642#M531254 <HTML><HEAD></HEAD><BODY><P style="font-size: 13.3333330154419px;">Hi </P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Below is my Requirement</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Dimension - &gt; Date</P><P style="font-size: 13.3333330154419px;">Need to find the average of Time Diff between EndDate and Start Date for Distinct MAR</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">In the Attached file the average should be 45:35:50</P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Note: Source file attached as excel in <A href="https://community.qlik.com/thread/167431">Distinct Sum</A></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;"></P><P style="font-size: 13.3333330154419px;">Regards,</P><P style="font-size: 13.3333330154419px;">Senthil</P></BODY></HTML> Mon, 08 Jun 2015 13:08:56 GMT https://community.qlik.com/t5/QlikView/Sum-of-Distinct-Records/m-p/847642#M531254 2015-06-08T13:08:56Z