topic Re: Is it possible in QlikView.... in QlikView https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391497#M568791 <HTML><HEAD></HEAD><BODY><P>Add the product and Month/Year to your dimensions</P><P></P><P>Then on the report itseld, drag and drop them above your expressions</P></BODY></HTML> Mon, 08 Oct 2012 13:25:46 GMT 2012-10-08T13:25:46Z Is it possible in QlikView.... https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391496#M568790 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>I got a new requirement from my client.I want to develop a 4 report that is in tabular format like....</P><P></P><TABLE border="0" cellspacing="0" frame="VOID" rules="NONE"><TBODY><TR><TD bgcolor="#00FF00" height="51" rowspan="3" style="border: 1px solid #000000;" width="104"><STRONG style="color: #000000; font-size: 12pt; font-family: Verdana;">Dimension</STRONG></TD><TD bgcolor="#00FF00" colspan="10" style="border: 1px solid #000000;" width="899"><STRONG style="color: #000000; font-family: Verdana;">Product 1</STRONG></TD><TD bgcolor="#00FF00" colspan="10" style="border: 1px solid #000000;" width="893"><STRONG style="color: #000000; font-family: Verdana;">Product 2</STRONG></TD></TR><TR><TD bgcolor="#FF0000" colspan="3" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Oct'12</STRONG></TD><TD bgcolor="#FF0000" colspan="3" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">YTD Oct'12</STRONG></TD><TD bgcolor="#FF0000" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;"><BR /></STRONG></TD><TD bgcolor="#FF0000" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;"><BR /></STRONG></TD><TD bgcolor="#FF0000" colspan="2" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Growth % Over</STRONG></TD><TD bgcolor="#FF0000" colspan="3" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Oct'12</STRONG></TD><TD bgcolor="#FF0000" colspan="3" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">YTD Oct'12</STRONG></TD><TD bgcolor="#FF0000" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;"><BR /></STRONG></TD><TD bgcolor="#FF0000" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;"><BR /></STRONG></TD><TD bgcolor="#FF0000" colspan="2" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Growth % Over</STRONG></TD></TR><TR><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Sales</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Target</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">% Target</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Sales</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Target</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">% Target</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Oct'11</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Dec'11</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Current Month</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">YTD</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Sales</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;"> Target </STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">% Target</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Sales</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Target</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">% Target</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Oct'11</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Dec'11</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">Current month</STRONG></TD><TD bgcolor="#00FF00" style="border: 1px solid #000000;"><STRONG style="color: #000000; font-family: Verdana;">YTD</STRONG></TD></TR></TBODY></TABLE><P></P><P>I never develop and didn't seen like this report in qlikview.In this report product is a dimension,that we can drag from rows to columns this we can do it and measures in green colour also we can do it,but my question is how to display Oct'12,YTD Oct'12 and Growth % Over(which is in red colours) in the table.Is there any way to display these format in qlikview.</P><P></P><P>I know we can represent text objects in the top of the table.</P><P>But my client is taking this report from access point and converting it into excel with one click.</P><P>Can any body know the solution for this..</P><P>Thanks in advance,</P><P></P><P>regards,</P><P>baru</P></BODY></HTML> Mon, 08 Oct 2012 13:21:22 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391496#M568790 2012-10-08T13:21:22Z Re: Is it possible in QlikView.... https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391497#M568791 <HTML><HEAD></HEAD><BODY><P>Add the product and Month/Year to your dimensions</P><P></P><P>Then on the report itseld, drag and drop them above your expressions</P></BODY></HTML> Mon, 08 Oct 2012 13:25:46 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391497#M568791 2012-10-08T13:25:46Z Re: Is it possible in QlikView.... https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391498#M568792 <HTML><HEAD></HEAD><BODY><P>Hi Brianm,</P><P></P><P>thanks for your reply,</P><P></P><P>can i have any sample example about this format and product and month/year together in dimension.</P><P></P><P></P><P>regards,</P><P>baru</P></BODY></HTML> Mon, 08 Oct 2012 13:30:54 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391498#M568792 2012-10-08T13:30:54Z Re: Is it possible in QlikView.... https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391499#M568793 <HTML><HEAD></HEAD><BODY><P>Hi, </P><P></P><P>I think you need to use ValueList() in dimension.&nbsp; Hope attached file helps you.&nbsp; You need to generate the ValueList() values dynamically based on the date.&nbsp; In attached it is hard coded values in ValueList().</P><P></P><P>Regards,</P><P>Jagan.</P></BODY></HTML> Mon, 08 Oct 2012 14:06:06 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391499#M568793 jagan 2012-10-08T14:06:06Z Re: Is it possible in QlikView.... https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391500#M568794 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>can any one have idea about this..</P><P></P><P></P><P>reards.</P><P>baru</P></BODY></HTML> Tue, 09 Oct 2012 09:33:14 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391500#M568794 2012-10-09T09:33:14Z Re: Is it possible in QlikView.... https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391501#M568795 <HTML><HEAD></HEAD><BODY><P>Hi Community,</P><P></P><P>Can anybody help in this issue or</P><P>is it possible to write in macro to resolve this issue,getting column name(which is in red colour).</P><P></P><P>thanks in advance,</P><P></P><P>regards,</P><P>baru</P></BODY></HTML> Thu, 11 Oct 2012 10:52:47 GMT https://community.qlik.com/t5/QlikView/Is-it-possible-in-QlikView/m-p/391501#M568795 2012-10-11T10:52:47Z