topic Re: function peek() in QlikView https://community.qlik.com/t5/QlikView/function-peek/m-p/428952#M1158713 <HTML><HEAD></HEAD><BODY><P>Here is an example, hope it helps</P></BODY></HTML> Tue, 12 Feb 2013 15:24:18 GMT alexandros17 2013-02-12T15:24:18Z function peek() https://community.qlik.com/t5/QlikView/function-peek/m-p/428951#M1158712 <HTML><HEAD></HEAD><BODY><P>I need to perform the following pivot table design</P><P></P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="91" style="width: 368px; border: 1px solid rgb(0, 0, 0); height: 81px;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Qty</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Price</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>CD</TD><TD>20</TD><TD>10</TD></TR><TR><TD>2</TD><TD>DVD</TD><TD>15</TD><TD>15</TD></TR><TR><TD>3</TD><TD>Blu-ray</TD><TD>25</TD><TD>20</TD></TR></TBODY></TABLE><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="91" style="width: 369px; border: 1px solid #000000; height: 55px;" width="367"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>ID</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Input</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Output</STRONG></SPAN></TH></TR><TR><TD>1</TD><TD>5</TD><TD>10</TD></TR><TR><TD>2</TD><TD>10</TD><TD>10</TD></TR><TR><TD>3</TD><TD>10</TD><TD>15</TD></TR></TBODY></TABLE><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="114" style="font-size: 10pt; width: 636px; border: 1px solid rgb(0, 0, 0); height: 92px;"><TBODY><TR><TH align="center" rowspan="2" style="background-color: #6690bc;" valign="middle"><STRONG style="color: #ffffff; text-align: -webkit-center; background-color: #6690bc;">ID</STRONG><BR /></TH><TH align="center" rowspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Product</STRONG></SPAN><BR /></TH><TH align="center" rowspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Stock</STRONG></SPAN><BR /></TH><TH align="center" colspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Input</STRONG></SPAN></TH><TH align="center" rowspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Total Input</STRONG></SPAN><BR /></TH><TH align="center" colspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Output</STRONG></SPAN></TH><TH align="center" rowspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Total Output</STRONG></SPAN><BR /></TH><TH align="center" rowspan="2" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG> Total </STRONG></SPAN><BR /></TH></TR><TR><TD>Qty</TD><TD>Price</TD><TD>Qty</TD><TD>Price</TD></TR><TR><TD>1</TD><TD>CD</TD><TD>20</TD><TD>5</TD><TD>10</TD><TD>25</TD><TD>10</TD><TD>10</TD><TD>15</TD><TD>150</TD></TR><TR><TD>2</TD><TD>DVD</TD><TD>15</TD><TD>10</TD><TD>15</TD><TD>25</TD><TD>10</TD><TD>15</TD><TD>15</TD><TD>225</TD></TR><TR><TD>3</TD><TD>Blu-ray</TD><TD>25</TD><TD>10</TD><TD>20</TD><TD>35</TD><TD>15</TD><TD>20</TD><TD>15</TD><TD>300</TD></TR></TBODY></TABLE></BODY></HTML> Tue, 12 Feb 2013 15:04:21 GMT https://community.qlik.com/t5/QlikView/function-peek/m-p/428951#M1158712 omarlq20 2013-02-12T15:04:21Z Re: function peek() https://community.qlik.com/t5/QlikView/function-peek/m-p/428952#M1158713 <HTML><HEAD></HEAD><BODY><P>Here is an example, hope it helps</P></BODY></HTML> Tue, 12 Feb 2013 15:24:18 GMT https://community.qlik.com/t5/QlikView/function-peek/m-p/428952#M1158713 alexandros17 2013-02-12T15:24:18Z Re: function peek() https://community.qlik.com/t5/QlikView/function-peek/m-p/428953#M1158714 <HTML><HEAD></HEAD><BODY><P>I need titles appear the way you've placed, input as title and subtitle below as quantity and price.</P></BODY></HTML> Tue, 12 Feb 2013 15:27:51 GMT https://community.qlik.com/t5/QlikView/function-peek/m-p/428953#M1158714 omarlq20 2013-02-12T15:27:51Z Re: function peek() https://community.qlik.com/t5/QlikView/function-peek/m-p/428954#M1158715 <HTML><HEAD></HEAD><BODY><P>It would be beautiful but it's not possible ... sorry</P></BODY></HTML> Tue, 12 Feb 2013 15:40:11 GMT https://community.qlik.com/t5/QlikView/function-peek/m-p/428954#M1158715 alexandros17 2013-02-12T15:40:11Z Re: function peek() https://community.qlik.com/t5/QlikView/function-peek/m-p/428955#M1158716 <HTML><HEAD></HEAD><BODY><P>never say its not possible</P><P>see the attached file</P><P></P><P></P><P></P><P></P><P>hope this helps</P></BODY></HTML> Tue, 12 Feb 2013 15:45:01 GMT https://community.qlik.com/t5/QlikView/function-peek/m-p/428955#M1158716 SunilChauhan 2013-02-12T15:45:01Z Re: function peek() https://community.qlik.com/t5/QlikView/function-peek/m-p/428956#M1158717 <HTML><HEAD></HEAD><BODY><P>Yes but it's not exactly what he needs ...</P></BODY></HTML> Tue, 12 Feb 2013 15:55:00 GMT https://community.qlik.com/t5/QlikView/function-peek/m-p/428956#M1158717 alexandros17 2013-02-12T15:55:00Z Re: function peek() https://community.qlik.com/t5/QlikView/function-peek/m-p/428957#M1158718 <HTML><HEAD></HEAD><BODY><P>Not exactly what I need, clearly, if you like what I require, but I need the totals to be displayed as a single field.</P></BODY></HTML> Tue, 12 Feb 2013 16:13:16 GMT https://community.qlik.com/t5/QlikView/function-peek/m-p/428957#M1158718 omarlq20 2013-02-12T16:13:16Z