topic Aggregate data in QlikView https://community.qlik.com/t5/QlikView/Aggregate-data/m-p/163121#M36343 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I have a problem during an analysis that I would like to know if u could sold it out.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I have a dataset of questionnaires like this:</P><P style="margin: 0cm 0cm 0pt;"></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="margin: auto auto auto -1.15pt; width: 541pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="721"><TBODY><TR style="height: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 3.5pt; padding-left: 3.5pt; padding-bottom: 0cm; width: 11pt; padding-top: 0cm; height: 15pt; background-color: transparent; border: windowtext 1pt solid;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt;">#</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P3s1</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;">P3s2</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">P3s3</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">P4_1</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">P4_2</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">P4_3</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 1;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">1</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">O sistema de saúde</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 2;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">2</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">FREQUENTEMENTE</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 3;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">3</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">FREQUENTEMENTE</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 4;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">4</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;">A habitação</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">NUNCA</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 5;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">5</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 6;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">6</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;">A habitação</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">FREQUENTEMENTE</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 7;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">7</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 8; mso-yfti-lastrow: yes;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">8</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">O sistema de saúde</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">NUNCA</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">NUNCA</P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">As u can see, P3s1 to 3, is the same question but with multiple answers. P3s1 to 3 can only admit one question.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">In P4_1 to 3 is different, is only one question as well but it admit 5 possible answers.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">For both cases I want to bill a table, simple or dynamic, like this:</P><P style="margin: 0cm 0cm 0pt;"></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="margin: auto auto auto -1.15pt; width: 133pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="177"><TBODY><TR style="height: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 3.5pt; padding-left: 3.5pt; padding-bottom: 0cm; width: 74pt; padding-top: 0cm; height: 12.75pt; background-color: transparent; border: windowtext 1pt solid;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">Question</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 12.75pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;">Answer (count)</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 1;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P3s4</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt; text-align: right">10</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 2;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P3s5</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt; text-align: right">12</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 3; mso-yfti-lastrow: yes;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P3s6</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt; text-align: right">13</P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;"></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="margin: auto auto auto -1.15pt; width: 340.35pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="454"><TBODY><TR style="height: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 3.5pt; padding-left: 3.5pt; padding-bottom: 0cm; width: 74pt; padding-top: 0cm; height: 12.75pt; background-color: transparent; border: windowtext 1pt solid;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">Question</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 69.35pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 12.75pt; background-color: transparent;" valign="bottom" width="92"><P style="margin: 0cm 0cm 0pt;">Frequetemente</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 12.75pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">De vez em quando</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 12.75pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">Nunca</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 1;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P4_1</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 69.35pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="92"><P style="margin: 0cm 0cm 0pt;">xx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">xxx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">xx</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 2;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P4_2</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 69.35pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="92"><P style="margin: 0cm 0cm 0pt;">xx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">xxx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">xx</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 3; mso-yfti-lastrow: yes;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P4_3</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 69.35pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="92"><P style="margin: 0cm 0cm 0pt;">xx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">xx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">xx</P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I don't know how to do it. Can u help me?</P></BODY></HTML> Tue, 11 Jan 2011 11:26:36 GMT 2011-01-11T11:26:36Z Aggregate data https://community.qlik.com/t5/QlikView/Aggregate-data/m-p/163121#M36343 <HTML><HEAD></HEAD><BODY><P style="margin: 0cm 0cm 0pt;">I have a problem during an analysis that I would like to know if u could sold it out.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I have a dataset of questionnaires like this:</P><P style="margin: 0cm 0cm 0pt;"></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="margin: auto auto auto -1.15pt; width: 541pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="721"><TBODY><TR style="height: 15pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 3.5pt; padding-left: 3.5pt; padding-bottom: 0cm; width: 11pt; padding-top: 0cm; height: 15pt; background-color: transparent; border: windowtext 1pt solid;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt;">#</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P3s1</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;">P3s2</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">P3s3</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">P4_1</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">P4_2</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">P4_3</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 1;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">1</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">O sistema de saúde</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 2;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">2</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">FREQUENTEMENTE</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 3;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">3</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">FREQUENTEMENTE</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 4;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">4</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;">A habitação</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">NUNCA</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 5;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">5</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 6;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">6</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;">A habitação</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">FREQUENTEMENTE</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 7;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">7</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 8; mso-yfti-lastrow: yes;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 11pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="15"><P style="margin: 0cm 0cm 0pt; text-align: right">8</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">O desemprego</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;"></P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">O sistema de saúde</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">DE VEZ EM QUANDO</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">NUNCA</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">NUNCA</P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">As u can see, P3s1 to 3, is the same question but with multiple answers. P3s1 to 3 can only admit one question.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">In P4_1 to 3 is different, is only one question as well but it admit 5 possible answers.</P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">For both cases I want to bill a table, simple or dynamic, like this:</P><P style="margin: 0cm 0cm 0pt;"></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="margin: auto auto auto -1.15pt; width: 133pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="177"><TBODY><TR style="height: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 3.5pt; padding-left: 3.5pt; padding-bottom: 0cm; width: 74pt; padding-top: 0cm; height: 12.75pt; background-color: transparent; border: windowtext 1pt solid;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">Question</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 12.75pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt;">Answer (count)</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 1;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P3s4</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt; text-align: right">10</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 2;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P3s5</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt; text-align: right">12</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 3; mso-yfti-lastrow: yes;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P3s6</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 59pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="79"><P style="margin: 0cm 0cm 0pt; text-align: right">13</P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;"></P><TABLE border="0" cellpadding="0" cellspacing="0" class="MsoNormalTable" style="margin: auto auto auto -1.15pt; width: 340.35pt; border-collapse: collapse; mso-yfti-tbllook: 1184; mso-padding-alt: 0cm 0cm 0cm 0cm;" width="454"><TBODY><TR style="height: 12.75pt; mso-yfti-irow: 0; mso-yfti-firstrow: yes;"><TD style="padding-right: 3.5pt; padding-left: 3.5pt; padding-bottom: 0cm; width: 74pt; padding-top: 0cm; height: 12.75pt; background-color: transparent; border: windowtext 1pt solid;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">Question</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 69.35pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 12.75pt; background-color: transparent;" valign="bottom" width="92"><P style="margin: 0cm 0cm 0pt;">Frequetemente</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 12.75pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">De vez em quando</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: windowtext 1pt solid; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 12.75pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">Nunca</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 1;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P4_1</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 69.35pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="92"><P style="margin: 0cm 0cm 0pt;">xx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">xxx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">xx</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 2;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P4_2</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 69.35pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="92"><P style="margin: 0cm 0cm 0pt;">xx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">xxx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">xx</P></TD></TR><TR style="height: 15pt; mso-yfti-irow: 3; mso-yfti-lastrow: yes;"><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: windowtext 1pt solid; width: 74pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="99"><P style="margin: 0cm 0cm 0pt;">P4_3</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 69.35pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="92"><P style="margin: 0cm 0cm 0pt;">xx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 97pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="129"><P style="margin: 0cm 0cm 0pt;">xx</P></TD><TD style="border-right: windowtext 1pt solid; padding-right: 3.5pt; border-top: #f0f0f0; padding-left: 3.5pt; padding-bottom: 0cm; border-left: #f0f0f0; width: 100pt; padding-top: 0cm; border-bottom: windowtext 1pt solid; height: 15pt; background-color: transparent;" valign="bottom" width="133"><P style="margin: 0cm 0cm 0pt;">xx</P></TD></TR></TBODY></TABLE><P style="margin: 0cm 0cm 0pt;"></P><P style="margin: 0cm 0cm 0pt;">I don't know how to do it. Can u help me?</P></BODY></HTML> Tue, 11 Jan 2011 11:26:36 GMT https://community.qlik.com/t5/QlikView/Aggregate-data/m-p/163121#M36343 2011-01-11T11:26:36Z