topic Re: Table design in QlikView https://community.qlik.com/t5/QlikView/Table-design/m-p/371560#M1174975 <HTML><HEAD></HEAD><BODY><P> Use pivot table and add dimension Year, Month, Sales field.</P><P>In presentation tab uncheck "Supress zero values". </P><P></P><P>I hope this helps you.</P><P></P><P>Regards</P><P>Venkat</P></BODY></HTML> Fri, 27 Apr 2012 07:44:51 GMT 2012-04-27T07:44:51Z Table design https://community.qlik.com/t5/QlikView/Table-design/m-p/371558#M1174973 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>How i can design a table in the report, like:</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 35%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Year</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Month</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Sales</STRONG></SPAN></TH></TR><TR><TD>2010</TD><TD>2010.05</TD><TD>100</TD></TR><TR><TD><BR /></TD><TD>2010.06</TD><TD>200</TD></TR><TR><TD><BR /></TD><TD>2010.09</TD><TD>123</TD></TR><TR><TD><BR /></TD><TD>2010.11</TD><TD>444</TD></TR><TR><TD>2011</TD><TD>2011.01</TD><TD>222</TD></TR><TR><TD><BR /></TD><TD>2011.05</TD><TD>111</TD></TR><TR><TD><BR /></TD><TD>2011.11</TD><TD>100</TD></TR><TR><TD>2012</TD><TD>2012.02</TD><TD>200</TD></TR><TR><TD><BR /></TD><TD>2012.03</TD><TD>300</TD></TR><TR><TD><BR /></TD><TD>2012.04</TD><TD>300</TD></TR></TBODY></TABLE></BODY></HTML> Fri, 27 Apr 2012 07:31:38 GMT https://community.qlik.com/t5/QlikView/Table-design/m-p/371558#M1174973 Anonymous 2012-04-27T07:31:38Z Table design https://community.qlik.com/t5/QlikView/Table-design/m-p/371559#M1174974 <HTML><HEAD></HEAD><BODY><P> Use this<SPAN style=": ; color: #0000ff; font-size: 1;"></SPAN></P><P></P><P></P><P>if(<SPAN style="color: #0000ff; font-size: 8pt;">Above</SPAN><SPAN style="font-size: 8pt;">(</SPAN><SPAN style="color: #0000ff; font-size: 8pt;">Total</SPAN><SPAN style="font-size: 8pt;"> </SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">) = </SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">, ' " ', </SPAN><SPAN style="color: #800000; font-size: 8pt;">Year</SPAN><SPAN style="font-size: 8pt;">) </SPAN></P><P></P><P><SPAN style="font-size: 8pt;"> </SPAN> </P><P>This will work in Expression, not in dimension. Straight table, hide dimension column.</P><P></P><P>HTH</P><P>Shubhu </P></BODY></HTML> Fri, 27 Apr 2012 07:42:55 GMT https://community.qlik.com/t5/QlikView/Table-design/m-p/371559#M1174974 2012-04-27T07:42:55Z Re: Table design https://community.qlik.com/t5/QlikView/Table-design/m-p/371560#M1174975 <HTML><HEAD></HEAD><BODY><P> Use pivot table and add dimension Year, Month, Sales field.</P><P>In presentation tab uncheck "Supress zero values". </P><P></P><P>I hope this helps you.</P><P></P><P>Regards</P><P>Venkat</P></BODY></HTML> Fri, 27 Apr 2012 07:44:51 GMT https://community.qlik.com/t5/QlikView/Table-design/m-p/371560#M1174975 2012-04-27T07:44:51Z Re: Table design https://community.qlik.com/t5/QlikView/Table-design/m-p/371561#M1174976 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>In pivot table </P><P>Add Dimensions - Year and Month, </P><P>Expression - sum (sales)</P><P></P><P>Regards,</P><P>P.Prasath</P></BODY></HTML> Fri, 27 Apr 2012 08:10:19 GMT https://community.qlik.com/t5/QlikView/Table-design/m-p/371561#M1174976 2012-04-27T08:10:19Z