topic Qlik Sense - Top 10 Table in Connectivity & Data Prep https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Top-10-Table/m-p/1444945#M3297 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a top 10 table created, using the limitation dropdown in Qlik Sense. The data set has multiple months worth of data. But I only want to show one line for each user ID.</P><P></P><P>So in example below I just want to show user ID once and I want Qlik to show the latest period?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>User ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Period</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Count</STRONG></TH></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">Mar-17</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">DGF</TD><TD style="padding: 2px;">Jun-17</TD><TD style="padding: 2px;">85</TD></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">Jul-17</TD><TD style="padding: 2px;">63</TD></TR><TR><TD style="padding: 2px;">ZXC</TD><TD style="padding: 2px;">Jul-17</TD><TD style="padding: 2px;">77</TD></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">May-17</TD><TD style="padding: 2px;">68</TD></TR><TR><TD style="padding: 2px;">DGF</TD><TD style="padding: 2px;">Mar-17</TD><TD style="padding: 2px;">35</TD></TR></TBODY></TABLE><P></P><P></P><P>So what I was aiming to get the below, hopefully!</P><P></P><P>Thanks,</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>User ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Period</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Count</STRONG></TH></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">Jul-17</TD><TD style="padding: 2px;">63</TD></TR><TR><TD style="padding: 2px;">DGF</TD><TD style="padding: 2px;">Jun-17</TD><TD style="padding: 2px;">85</TD></TR><TR><TD style="padding: 2px;">ZXC</TD><TD style="padding: 2px;">Jul-17</TD><TD style="padding: 2px;">77</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 22 Aug 2017 14:36:42 GMT 2017-08-22T14:36:42Z Qlik Sense - Top 10 Table https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Top-10-Table/m-p/1444945#M3297 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I have a top 10 table created, using the limitation dropdown in Qlik Sense. The data set has multiple months worth of data. But I only want to show one line for each user ID.</P><P></P><P>So in example below I just want to show user ID once and I want Qlik to show the latest period?</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>User ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Period</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Count</STRONG></TH></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">Mar-17</TD><TD style="padding: 2px;">100</TD></TR><TR><TD style="padding: 2px;">DGF</TD><TD style="padding: 2px;">Jun-17</TD><TD style="padding: 2px;">85</TD></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">Jul-17</TD><TD style="padding: 2px;">63</TD></TR><TR><TD style="padding: 2px;">ZXC</TD><TD style="padding: 2px;">Jul-17</TD><TD style="padding: 2px;">77</TD></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">May-17</TD><TD style="padding: 2px;">68</TD></TR><TR><TD style="padding: 2px;">DGF</TD><TD style="padding: 2px;">Mar-17</TD><TD style="padding: 2px;">35</TD></TR></TBODY></TABLE><P></P><P></P><P>So what I was aiming to get the below, hopefully!</P><P></P><P>Thanks,</P><P></P><TABLE border="1" class="jiveBorder" style="border: 1px solid rgb(0, 0, 0); border-image: none; width: 100%;"><TBODY><TR><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>User ID</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Period</STRONG></TH><TH style="text-align: center; background-color: #6690bc; color: #ffffff; padding: 2px;" valign="middle"><STRONG>Count</STRONG></TH></TR><TR><TD style="padding: 2px;">ABC</TD><TD style="padding: 2px;">Jul-17</TD><TD style="padding: 2px;">63</TD></TR><TR><TD style="padding: 2px;">DGF</TD><TD style="padding: 2px;">Jun-17</TD><TD style="padding: 2px;">85</TD></TR><TR><TD style="padding: 2px;">ZXC</TD><TD style="padding: 2px;">Jul-17</TD><TD style="padding: 2px;">77</TD></TR><TR><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD><TD style="padding: 2px;"></TD></TR></TBODY></TABLE></BODY></HTML> Tue, 22 Aug 2017 14:36:42 GMT https://community.qlik.com/t5/Connectivity-Data-Prep/Qlik-Sense-Top-10-Table/m-p/1444945#M3297 2017-08-22T14:36:42Z