topic Re: Show all values pivot table in QlikView https://community.qlik.com/t5/QlikView/Show-all-values-pivot-table/m-p/516812#M192924 <HTML><HEAD></HEAD><BODY><P>The built in QlikView pivot table should give you what you're asking for (see attached).</P></BODY></HTML> Mon, 02 Dec 2013 17:10:23 GMT Nicole-Smith 2013-12-02T17:10:23Z Show all values pivot table https://community.qlik.com/t5/QlikView/Show-all-values-pivot-table/m-p/516811#M192923 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I need your help, i want to show all values in a dimension</P><P>Finally i want to display this pivot table</P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" width="633"><TBODY><TR><TD class="xl73" height="20" width="98">Name</TD><TD class="xl73" style="border-left: none;" width="98">Reg</TD><TD class="xl74" style="border-left: none;" width="316">Prod</TD><TD class="xl65" width="121">value</TD></TR><TR><TD class="xl69" height="40" rowspan="2" style="border-bottom: .5pt solid black; border-top: none;">a</TD><TD class="xl66" style="border-top: none; border-left: none;">aa</TD><TD class="xl68" style="border-top: none; border-left: none;">Prod1</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl66" height="20" style="border-top: none; border-left: none;">aa1</TD><TD class="xl75" style="border-top: none; border-left: none;">Prod2</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">2</TD></TR><TR><TD class="xl69" height="60" rowspan="3" style="border-bottom: .5pt solid black; border-top: none;">b</TD><TD class="xl66" style="border-top: none; border-left: none;">bb</TD><TD class="xl75" style="border-top: none; border-left: none;">Prod3</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl66" height="20" style="border-top: none; border-left: none;">bb1</TD><TD class="xl75" style="border-top: none; border-left: none;">Prod4</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">0</TD></TR><TR><TD class="xl66" height="20" style="border-top: none; border-left: none;">bb3</TD><TD class="xl75" style="border-top: none; border-left: none;">Prod5</TD><TD align="right" class="xl67" style="border-top: none; border-left: none;">5</TD></TR></TBODY></TABLE><P></P><P>when user select " a " i will have in my pivot table </P><P></P><TABLE border="0" cellpadding="0" cellspacing="0" style="width: 633px;"><TBODY><TR><TD class="xl68" height="40" rowspan="2" style="border-bottom: .5pt solid black;" width="98">a</TD><TD class="xl65" style="border-left: none;" width="98">aa</TD><TD class="xl67" style="border-left: none;" width="316">Prod1</TD><TD align="right" class="xl66" style="border-left: none;" width="121">0</TD></TR><TR><TD class="xl65" height="20" style="border-top: none; border-left: none;">aa1</TD><TD class="xl70" style="border-top: none; border-left: none;">Prod2</TD><TD align="right" class="xl66" style="border-top: none; border-left: none;">2</TD></TR></TBODY></TABLE><P></P><P>Have you any idea to to that</P><P></P><P>Many thanks for your help</P><P></P><P>Emteam</P></BODY></HTML> Mon, 02 Dec 2013 16:53:25 GMT https://community.qlik.com/t5/QlikView/Show-all-values-pivot-table/m-p/516811#M192923 emteam162 2013-12-02T16:53:25Z Re: Show all values pivot table https://community.qlik.com/t5/QlikView/Show-all-values-pivot-table/m-p/516812#M192924 <HTML><HEAD></HEAD><BODY><P>The built in QlikView pivot table should give you what you're asking for (see attached).</P></BODY></HTML> Mon, 02 Dec 2013 17:10:23 GMT https://community.qlik.com/t5/QlikView/Show-all-values-pivot-table/m-p/516812#M192924 Nicole-Smith 2013-12-02T17:10:23Z