topic need help in crosstab pivot in QlikView https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264854#M1188412 <HTML><HEAD></HEAD><BODY><P>HI </P><P></P><P>Once you see blue arrow facing upwards then drag towards the right side of the oject near close button so that it chages from horizontal arrow to vrtical arrow</P><P></P><P>then release the mouse hold</P><P></P><P>Regards</P><P>Venkatesh Salla</P></BODY></HTML> Thu, 11 Aug 2011 06:22:57 GMT 2011-08-11T06:22:57Z need help in crosstab pivot https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264851#M1188409 <HTML><HEAD></HEAD><BODY><P>hi im new in QV and i need your help</P><P></P><P>i have this flat tables</P><P></P><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" height="160" style="height: 131px; width: 181px; border-width: 1px; border-color: #000000; border-style: solid;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle">Customer<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Month<BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle">Amt<BR /></TH></TR><TR><TD>Dave</TD><TD>Jan</TD><TD>1,000</TD></TR><TR><TD style="text-align: left;"><DIV style="text-align: -webkit-center;">Dave</DIV></TD><TD>Feb</TD><TD>500</TD></TR><TR><TD>Dave</TD><TD>May</TD><TD>600</TD></TR><TR><TD>Dave</TD><TD>Dec</TD><TD><P>7000</P></TD></TR><TR><TD>John</TD><TD>Feb</TD><TD>5600</TD></TR><TR><TD>John</TD><TD>Mar</TD><TD><P>400</P></TD></TR></TBODY></TABLE><P></P><P></P><P></P><P></P><P></P><P>Into this kind of format</P><H6><TABLE border="1" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 1px solid #000000;"><TBODY><TR><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Customer</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Jan</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Feb</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Mar</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Apr</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>May</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #333333;"><H6>Jun</H6></SPAN><BR /></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;">Jul</SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Aug</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>.....</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Dec</STRONG></SPAN></TH><TH align="center" style="background-color: #6690bc;" valign="middle"><SPAN style="color: #ffffff;"><STRONG>Total</STRONG></SPAN></TH></TR><TR><TD>Dave</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD>John</TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR><TR><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD><TD><BR /></TD></TR></TBODY></TABLE></H6><P></P><P>Hope you could help me....</P></BODY></HTML> Thu, 11 Aug 2011 03:16:13 GMT https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264851#M1188409 rotero 2011-08-11T03:16:13Z need help in crosstab pivot https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264852#M1188410 <HTML><HEAD></HEAD><BODY><P>HI</P><P></P><P>Please find the image for your query. You have to select pivot table in the object selection and frist dim as Customer</P><P>Second dim as month </P><P>and in expersion you to select sum(amt)</P><P></P><P>com back to to presentaion tab (find the screen shot for the same)</P><P> select Month Diminsion and check the show patila sums check box.</P><P></P><P>and on the GUI select the mon the drag upward the blue arrow show in vertical way and leave in </P><P></P><P>Hope you got your answer</P><P></P><P>Regards</P><P>Venkatesh Salla</P><P><IMG alt="Qlikview_Example_Pivot.bmp" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/6424_Qlikview_Example_Pivot.bmp" width="450" /></P></BODY></HTML> Thu, 11 Aug 2011 05:30:12 GMT https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264852#M1188410 2011-08-11T05:30:12Z need help in crosstab pivot https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264853#M1188411 <HTML><HEAD></HEAD><BODY><P>im using Persnal Ed of QV.. and i try to do what u are trying to say.. i still dont have a tabular month column..... i saw the blue arrow but it doesnt take effect...</P></BODY></HTML> Thu, 11 Aug 2011 06:18:16 GMT https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264853#M1188411 rotero 2011-08-11T06:18:16Z need help in crosstab pivot https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264854#M1188412 <HTML><HEAD></HEAD><BODY><P>HI </P><P></P><P>Once you see blue arrow facing upwards then drag towards the right side of the oject near close button so that it chages from horizontal arrow to vrtical arrow</P><P></P><P>then release the mouse hold</P><P></P><P>Regards</P><P>Venkatesh Salla</P></BODY></HTML> Thu, 11 Aug 2011 06:22:57 GMT https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264854#M1188412 2011-08-11T06:22:57Z need help in crosstab pivot https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264855#M1188413 <HTML><HEAD></HEAD><BODY><P><IMG alt="pivot success.jpg" class="jive-image-thumbnail jive-image" onclick="" src="https://community.qlik.com/legacyfs/online/6428_pivot+success.jpg" style="float: left;" width="450" /></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P></P><P>wow thank you .. i already solve my prob.... </P><P></P><P></P><P></P><P></P></BODY></HTML> Thu, 11 Aug 2011 06:32:33 GMT https://community.qlik.com/t5/QlikView/need-help-in-crosstab-pivot/m-p/264855#M1188413 rotero 2011-08-11T06:32:33Z