topic Breaks in a Table by Value in QlikView https://community.qlik.com/t5/QlikView/Breaks-in-a-Table-by-Value/m-p/346622#M128249 <HTML><HEAD></HEAD><BODY><P> its better to use pivot table to remove multiple entries of same value</P></BODY></HTML> Fri, 11 May 2012 05:37:42 GMT sivarajs 2012-05-11T05:37:42Z Breaks in a Table by Value https://community.qlik.com/t5/QlikView/Breaks-in-a-Table-by-Value/m-p/346621#M128248 <HTML><HEAD></HEAD><BODY><P>Please advise on the following problem. </P><P></P><P>I have data like this.&nbsp; I am using Straight Table.&nbsp; </P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Contry</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>State</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Revenue</STRONG></SPAN></TH></TR><TR><TD>USA</TD><TD>New York</TD><TD>2</TD></TR><TR><TD>USA</TD><TD>New York</TD><TD>3</TD></TR><TR><TD>USA</TD><TD>New Jersey</TD><TD>4</TD></TR><TR><TD>MEXICO</TD><TD>State1</TD><TD>5</TD></TR><TR><TD>MEXICO</TD><TD>State2</TD><TD>6</TD></TR></TBODY></TABLE><P></P><P>However, I want the data like this.&nbsp; How can I remove the dupes in the first column ?</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Contry</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>State</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Revenue</STRONG></SPAN></TH></TR><TR><TD>USA</TD><TD>New York</TD><TD>2</TD></TR><TR><TD></TD><TD>New York</TD><TD>3</TD></TR><TR><TD></TD><TD>New Jersey</TD><TD>4</TD></TR><TR><TD>MEXICO</TD><TD>State1</TD><TD>5</TD></TR><TR><TD></TD><TD>State2</TD><TD>6</TD></TR></TBODY></TABLE><P><BR />-Regards.</P></BODY></HTML> Thu, 10 May 2012 18:12:56 GMT https://community.qlik.com/t5/QlikView/Breaks-in-a-Table-by-Value/m-p/346621#M128248 2012-05-10T18:12:56Z Breaks in a Table by Value https://community.qlik.com/t5/QlikView/Breaks-in-a-Table-by-Value/m-p/346622#M128249 <HTML><HEAD></HEAD><BODY><P> its better to use pivot table to remove multiple entries of same value</P></BODY></HTML> Fri, 11 May 2012 05:37:42 GMT https://community.qlik.com/t5/QlikView/Breaks-in-a-Table-by-Value/m-p/346622#M128249 sivarajs 2012-05-11T05:37:42Z