topic Concurrency Calculation in QlikView https://community.qlik.com/t5/QlikView/Concurrency-Calculation/m-p/746332#M266370 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an issue while doing the caclulation to find out the concurrent user (per Application, per vendor and Per Applion &amp;Vendor )</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 416px; BORDER-COLLAPSE: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="background-color: #92d050; width: 75pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="100"><SPAN style="color: #000000;">Application</SPAN></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">Vendor</SPAN></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; width: 71pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="94"><SPAN style="color: #000000;">Start Time</SPAN></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; width: 71pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="94"><SPAN style="color: #000000;">End Time</SPAN></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">User ID</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">A</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">X</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 10:50</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 14:07</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">11111</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000;">A</STRONG></TD><TD class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000;">Y</STRONG></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 11:07</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 16:07</SPAN></TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000;">22222</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">A</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">X</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">3-1-2011 10:50</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">3-1-2011 18:50</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">33333</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">B</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">Y</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 11:19</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 15:17</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">44444</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">B</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">X</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">2-1-2011 10:50</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">3-1-2011 11:50</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">11111</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">B</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">X</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 10:55</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 15:17</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">55555</SPAN></TD></TR></TBODY></TABLE><P>For Example I have the Above data and I need to find out the max Concurrent (at certain point of time ie. vary with timing ) user for Application A , For Vendor X&nbsp; and for Application A &amp; Vendor X (combindely). </P><P></P><P>Your help will be highly appriciated.</P><P></P><P>Thanks!</P><P>D J</P></BODY></HTML> Wed, 18 Feb 2015 16:05:54 GMT 2015-02-18T16:05:54Z Concurrency Calculation https://community.qlik.com/t5/QlikView/Concurrency-Calculation/m-p/746332#M266370 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have an issue while doing the caclulation to find out the concurrent user (per Application, per vendor and Per Applion &amp;Vendor )</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="WIDTH: 416px; BORDER-COLLAPSE: collapse;"><TBODY><TR style="height: 12.75pt;"><TD class="xl66" height="17" style="background-color: #92d050; width: 75pt; height: 12.75pt; border: windowtext 0.5pt solid;" width="100"><SPAN style="color: #000000;">Application</SPAN></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">Vendor</SPAN></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; width: 71pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="94"><SPAN style="color: #000000;">Start Time</SPAN></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; width: 71pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="94"><SPAN style="color: #000000;">End Time</SPAN></TD><TD class="xl66" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: #92d050; width: 48pt; border-top: windowtext 0.5pt solid; border-right: windowtext 0.5pt solid;" width="64"><SPAN style="color: #000000;">User ID</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">A</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">X</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 10:50</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 14:07</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">11111</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl69" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000;">A</STRONG></TD><TD class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000;">Y</STRONG></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 11:07</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 16:07</SPAN></TD><TD align="right" class="xl69" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><STRONG style="color: #000000;">22222</STRONG></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">A</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">X</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">3-1-2011 10:50</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">3-1-2011 18:50</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">33333</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">B</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">Y</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 11:19</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 15:17</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">44444</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">B</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">X</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">2-1-2011 10:50</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">3-1-2011 11:50</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">11111</SPAN></TD></TR><TR style="height: 12.75pt;"><TD class="xl67" height="17" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext 0.5pt solid; background-color: transparent; height: 12.75pt; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">B</SPAN></TD><TD class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">X</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 10:55</SPAN></TD><TD align="right" class="xl68" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">1-1-2011 15:17</SPAN></TD><TD align="right" class="xl67" style="border-bottom: windowtext 0.5pt solid; border-left: windowtext; background-color: transparent; border-top: windowtext; border-right: windowtext 0.5pt solid;"><SPAN style="color: #000000;">55555</SPAN></TD></TR></TBODY></TABLE><P>For Example I have the Above data and I need to find out the max Concurrent (at certain point of time ie. vary with timing ) user for Application A , For Vendor X&nbsp; and for Application A &amp; Vendor X (combindely). </P><P></P><P>Your help will be highly appriciated.</P><P></P><P>Thanks!</P><P>D J</P></BODY></HTML> Wed, 18 Feb 2015 16:05:54 GMT https://community.qlik.com/t5/QlikView/Concurrency-Calculation/m-p/746332#M266370 2015-02-18T16:05:54Z Re: Concurrency Calculation https://community.qlik.com/t5/QlikView/Concurrency-Calculation/m-p/746333#M266371 <HTML><HEAD></HEAD><BODY><P>Did you ever find a solution? I've got near enough the exact same requirement.</P></BODY></HTML> Wed, 24 Aug 2016 10:25:12 GMT https://community.qlik.com/t5/QlikView/Concurrency-Calculation/m-p/746333#M266371 shane_spencer 2016-08-24T10:25:12Z