topic Re: Frequency for repeated numbers in QlikView https://community.qlik.com/t5/QlikView/Frequency-for-repeated-numbers/m-p/961659#M946631 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109552_Capture.PNG" style="height: 210px; width: 620px;" /></P><P></P><P>Straight table with</P><P></P><P>Dimension:</P><P><STRONG>=Aggr(Count(JOBNO), JOBNO)</STRONG></P><P></P><P>Expressions</P><P><STRONG>=Count(DISTINCT JOBNO)</STRONG></P><P><STRONG>=Count(JOBNO)</STRONG></P><P><STRONG>=Count({&lt;Status = {'Completed'}&gt;}JOBNO)</STRONG></P><P><STRONG>=Count({&lt;Status = {'M-CUST'}&gt;}JOBNO)</STRONG></P><P><STRONG>=Count({&lt;Status = {'M-STC'}&gt;}JOBNO)</STRONG></P></BODY></HTML> Mon, 21 Dec 2015 11:02:31 GMT sunny_talwar 2015-12-21T11:02:31Z Frequency for repeated numbers https://community.qlik.com/t5/QlikView/Frequency-for-repeated-numbers/m-p/961658#M946630 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P></P><P>Can anyone please help me for my below requirement.</P><P></P><P>I have attached the data sheet where I have a date field, Jobno and status column.</P><P></P><P>I need a pivot table where I can see the frequency and count of jobs repeated by status. E.g.</P><P></P><P>2 jobs has been repeated 5 times for so and so status.</P><P></P><P>This is the example done in the excel sheet. ( Count will be different as data and below statistics are for different month)</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="491"><TBODY><TR><TD colspan="6" nowrap="nowrap" style="border: none; border-bottom: solid #9BC2E6 1.0pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="491"><P align="center" style="text-align: center;"><STRONG style="color: #44546a;">Repeated and Unique Orders</STRONG></P></TD></TR><TR><TD rowspan="2" style="border: none; border-bottom: solid #9BC2E6 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="107"><P align="center" style="text-align: center;"><STRONG style="color: #44546a;">Times Repeated</STRONG></P></TD><TD rowspan="2" style="border: none; border-bottom: solid #9BC2E6 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="78"><P align="center" style="text-align: center;"><STRONG style="color: #44546a;">Unique Orders</STRONG></P></TD><TD rowspan="2" style="border: none; border-bottom: solid #9BC2E6 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" width="76"><P align="center" style="text-align: center;"><STRONG style="color: #44546a;">Total Orders</STRONG></P></TD><TD colspan="3" nowrap="nowrap" style="border: none; border-bottom: solid #9BC2E6 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="229"><P align="center" style="text-align: center;"><STRONG style="color: #44546a;">Status</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="border: none; border-bottom: solid #9BC2E6 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="98"><P align="center" style="text-align: center;"><STRONG style="color: #44546a;">Completed</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid #9BC2E6 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P align="center" style="text-align: center;"><STRONG style="color: #44546a;">M-CUST</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: solid #9BC2E6 1.0pt; background: white; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="59"><P align="center" style="text-align: center;"><STRONG style="color: #44546a;">M-STC</STRONG></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="center" style="text-align: center;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P align="center" style="text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P align="center" style="text-align: center;"><SPAN style="color: black;">6</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="98"><P align="center" style="text-align: center;"><SPAN style="color: black;">0</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P align="center" style="text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="59"><P align="center" style="text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="center" style="text-align: center;"><SPAN style="color: black;">5</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P align="center" style="text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P align="center" style="text-align: center;"><SPAN style="color: black;">10</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="98"><P align="center" style="text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P align="center" style="text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="59"><P align="center" style="text-align: center;"><SPAN style="color: black;">5</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="center" style="text-align: center;"><SPAN style="color: black;">4</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P align="center" style="text-align: center;"><SPAN style="color: black;">9</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P align="center" style="text-align: center;"><SPAN style="color: black;">36</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="98"><P align="center" style="text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P align="center" style="text-align: center;"><SPAN style="color: black;">16</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="59"><P align="center" style="text-align: center;"><SPAN style="color: black;">17</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="center" style="text-align: center;"><SPAN style="color: black;">3</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P align="center" style="text-align: center;"><SPAN style="color: black;">35</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P align="center" style="text-align: center;"><SPAN style="color: black;">105</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="98"><P align="center" style="text-align: center;"><SPAN style="color: black;">19</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P align="center" style="text-align: center;"><SPAN style="color: black;">45</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="59"><P align="center" style="text-align: center;"><SPAN style="color: black;">41</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="center" style="text-align: center;"><SPAN style="color: black;">2</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P align="center" style="text-align: center;"><SPAN style="color: black;">218</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P align="center" style="text-align: center;"><SPAN style="color: black;">436</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="98"><P align="center" style="text-align: center;"><SPAN style="color: black;">105</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P align="center" style="text-align: center;"><SPAN style="color: black;">141</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="59"><P align="center" style="text-align: center;"><SPAN style="color: black;">190</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="center" style="text-align: center;"><SPAN style="color: black;">1</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P align="center" style="text-align: center;"><SPAN style="color: black;">1591</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P align="center" style="text-align: center;"><SPAN style="color: black;">1591</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="98"><P align="center" style="text-align: center;"><SPAN style="color: black;">860</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P align="center" style="text-align: center;"><SPAN style="color: black;">194</SPAN></P></TD><TD nowrap="nowrap" style="padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="59"><P align="center" style="text-align: center;"><SPAN style="color: black;">537</SPAN></P></TD></TR><TR><TD nowrap="nowrap" style="border-top: solid #5B9BD5 1.0pt; border-left: none; border-bottom: double #5B9BD5 2.25pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="107"><P align="center" style="text-align: center;"><STRONG style="color: black;">Total</STRONG></P></TD><TD nowrap="nowrap" style="border-top: solid #5B9BD5 1.0pt; border-left: none; border-bottom: double #5B9BD5 2.25pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="78"><P align="center" style="text-align: center;"><STRONG style="color: black;">1856</STRONG></P></TD><TD nowrap="nowrap" style="border-top: solid #5B9BD5 1.0pt; border-left: none; border-bottom: double #5B9BD5 2.25pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P align="center" style="text-align: center;"><STRONG style="color: black;">2184</STRONG></P></TD><TD nowrap="nowrap" style="border-top: solid #5B9BD5 1.0pt; border-left: none; border-bottom: double #5B9BD5 2.25pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="98"><P align="center" style="text-align: center;"><STRONG style="color: black;">989</STRONG></P></TD><TD nowrap="nowrap" style="border-top: solid #5B9BD5 1.0pt; border-left: none; border-bottom: double #5B9BD5 2.25pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="72"><P align="center" style="text-align: center;"><STRONG style="color: black;">402</STRONG></P></TD><TD nowrap="nowrap" style="border-top: solid #5B9BD5 1.0pt; border-left: none; border-bottom: double #5B9BD5 2.25pt; border-right: none; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="59"><P align="center" style="text-align: center;"><STRONG style="color: black;">793</STRONG></P></TD></TR><TR><TD colspan="2" nowrap="nowrap" style="border: none; border-bottom: double #5B9BD5 2.25pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="185"><P align="center" style="text-align: center;"><STRONG style="color: black;">Repeated Percentage</STRONG></P></TD><TD nowrap="nowrap" style="border: none; border-bottom: double #5B9BD5 2.25pt; padding: 0 5.4pt 0 5.4pt;" valign="bottom" width="76"><P align="center" style="text-align: center;"><STRONG style="color: black;">27%</STRONG></P></TD></TR></TBODY></TABLE></BODY></HTML> Mon, 21 Dec 2015 07:31:51 GMT https://community.qlik.com/t5/QlikView/Frequency-for-repeated-numbers/m-p/961658#M946630 malimohammed 2015-12-21T07:31:51Z Re: Frequency for repeated numbers https://community.qlik.com/t5/QlikView/Frequency-for-repeated-numbers/m-p/961659#M946631 <HTML><HEAD></HEAD><BODY><P>This?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/109552_Capture.PNG" style="height: 210px; width: 620px;" /></P><P></P><P>Straight table with</P><P></P><P>Dimension:</P><P><STRONG>=Aggr(Count(JOBNO), JOBNO)</STRONG></P><P></P><P>Expressions</P><P><STRONG>=Count(DISTINCT JOBNO)</STRONG></P><P><STRONG>=Count(JOBNO)</STRONG></P><P><STRONG>=Count({&lt;Status = {'Completed'}&gt;}JOBNO)</STRONG></P><P><STRONG>=Count({&lt;Status = {'M-CUST'}&gt;}JOBNO)</STRONG></P><P><STRONG>=Count({&lt;Status = {'M-STC'}&gt;}JOBNO)</STRONG></P></BODY></HTML> Mon, 21 Dec 2015 11:02:31 GMT https://community.qlik.com/t5/QlikView/Frequency-for-repeated-numbers/m-p/961659#M946631 sunny_talwar 2015-12-21T11:02:31Z