topic Re: Nested Table -count only First Value in QlikView https://community.qlik.com/t5/QlikView/Nested-Table-count-only-First-Value/m-p/484540#M1145921 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert.</P><P></P><P>As usually working fine!!</P><P></P><P>Thanks a lot.</P><P></P><P>Ariel</P></BODY></HTML> Tue, 16 Jul 2013 11:41:32 GMT ariel_klien 2013-07-16T11:41:32Z Nested Table -count only First Value https://community.qlik.com/t5/QlikView/Nested-Table-count-only-First-Value/m-p/484538#M1145919 <HTML><HEAD></HEAD><BODY><P>Hello all,</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I need help with the following:</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">i have a table like this:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="246" style="border: 1px solid #000000; margin: 1px 0; padding: 3px;"><TBODY><TR style="border: 0px;"><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Object_Type</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Object_ID</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DATE</STRONG></SPAN></TH></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">AAA</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">1</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">01/01/13</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">AAA</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">2</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">01/01/13</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">AAA</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">3</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">02/01/13</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>AAA</STRONG></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>2</STRONG></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>05/01/13</STRONG></TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>AAA</STRONG></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>1</STRONG></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>05/01/13</STRONG></TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">BBB</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">1</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">01/01/13</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">BBB</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">2</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">01/01/13</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">BBB</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">3</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">01/01/13</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">BBB</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">4</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">01/01/13</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>BBB</STRONG></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>4</STRONG></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><STRONG>02/01/13</STRONG></TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I need to count only the first Object_Type &amp; Object_ID .</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Discard the raw's in bolt.</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">If I will use count(Object_Id) in expression and Object_Type and Date in Dimensions I will get:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="138" style="border: 1px solid #000000; margin: 1px 0; padding: 3px;"><TBODY><TR style="border: 0px;"><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Object_Type</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>DATE</STRONG></SPAN></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Count(Object_ID)</STRONG></SPAN></TH></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">AAA</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">01/01/13</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">2</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">AAA</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">02/01/13</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">1</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">AAA</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">05/01/13</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">2</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">BBB</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">01/01/13</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">4</TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">BBB</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">02/01/13</TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;">1</TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">I need that the table will be like:</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;"></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="68" style="border: 1px solid #000000; margin: 1px 0; padding: 3px;"><TBODY><TR style="border: 0px;"><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><STRONG>Object_Type</STRONG></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><STRONG>DATE</STRONG></TH><TH align="center" style="border: 1px solid #000000; background-color: #6690bc;" valign="middle"><STRONG>Count</STRONG></TH></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">AAA</SPAN></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">01/01/13</SPAN></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">2</SPAN></TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">AAA</SPAN></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">02/01/13</SPAN></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">1</SPAN></TD></TR><TR style="border: 0px;"><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">BBB</SPAN></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">01/01/13</SPAN></TD><TD style="border: 1px solid #000000; margin: 1px; padding: 3px; text-align: center;"><SPAN style="color: #333333;">4</SPAN></TD></TR></TBODY></TABLE><P></P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">How can I achieve that?</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">BR</P><P style="background-color: #ffffff; color: #737373; font-family: Arial;">Ariel</P></BODY></HTML> Tue, 16 Jul 2013 09:20:40 GMT https://community.qlik.com/t5/QlikView/Nested-Table-count-only-First-Value/m-p/484538#M1145919 ariel_klien 2013-07-16T09:20:40Z Re: Nested Table -count only First Value https://community.qlik.com/t5/QlikView/Nested-Table-count-only-First-Value/m-p/484539#M1145920 <HTML><HEAD></HEAD><BODY><P>See attached qvw</P></BODY></HTML> Tue, 16 Jul 2013 09:57:04 GMT https://community.qlik.com/t5/QlikView/Nested-Table-count-only-First-Value/m-p/484539#M1145920 Gysbert_Wassenaar 2013-07-16T09:57:04Z Re: Nested Table -count only First Value https://community.qlik.com/t5/QlikView/Nested-Table-count-only-First-Value/m-p/484540#M1145921 <HTML><HEAD></HEAD><BODY><P>Hi Gysbert.</P><P></P><P>As usually working fine!!</P><P></P><P>Thanks a lot.</P><P></P><P>Ariel</P></BODY></HTML> Tue, 16 Jul 2013 11:41:32 GMT https://community.qlik.com/t5/QlikView/Nested-Table-count-only-First-Value/m-p/484540#M1145921 ariel_klien 2013-07-16T11:41:32Z