topic Re: Need help with Pivot in QlikView https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758375#M269882 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for your reply..</P><P></P><P>I am unable to open the file....</P><P></P><P>Sub2u&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Fri, 09 Jan 2015 03:25:57 GMT 2015-01-09T03:25:57Z Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758372#M269879 <HTML><HEAD></HEAD><BODY><P>Hi Folks,</P><P></P><P>Please help with attachment sample file.</P><P></P><P>Thanks in advance....</P><P>Sub2u</P></BODY></HTML> Fri, 09 Jan 2015 02:51:50 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758372#M269879 2015-01-09T02:51:50Z Re: Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758373#M269880 <HTML><HEAD></HEAD><BODY><P>see attached doc</P></BODY></HTML> Fri, 09 Jan 2015 03:13:45 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758373#M269880 2015-01-09T03:13:45Z Re: Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758374#M269881 <HTML><HEAD></HEAD><BODY><P>Hi Sub2a,</P><P></P><P>PFA</P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Fri, 09 Jan 2015 03:23:31 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758374#M269881 jyothish8807 2015-01-09T03:23:31Z Re: Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758375#M269882 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks for your reply..</P><P></P><P>I am unable to open the file....</P><P></P><P>Sub2u&nbsp;&nbsp;&nbsp;&nbsp; </P></BODY></HTML> Fri, 09 Jan 2015 03:25:57 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758375#M269882 2015-01-09T03:25:57Z Re: Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758376#M269883 <HTML><HEAD></HEAD><BODY><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Hi,</P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Thanks for your reply..</P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">I am unable to open the file....</P><P></P><P style="font-weight: inherit; font-style: inherit; font-family: inherit;">Sub2u&nbsp;&nbsp;&nbsp; </P><P class="jive-thread-reply-btn" style="margin: 26px 0 -10px; font-size: 0.9em; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"></P><DIV class="jive-thread-reply-btn-correct" style="font-weight: inherit; font-style: inherit; font-family: inherit;"><A _jive_internal="true" href="https://community.qlik.com/message/691750" style="margin: 0 20px 0 0; padding: 2px 14px 4px 28px; font-weight: bold; font-style: inherit; font-family: inherit; color: #3778c7; background-color: #f3f3f3;">Need help with Pivot</A><P></P></DIV></BODY></HTML> Fri, 09 Jan 2015 03:26:58 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758376#M269883 2015-01-09T03:26:58Z Re: Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758377#M269884 <HTML><HEAD></HEAD><BODY><P>Just create a chart-&gt;pivot table</P><P>add two dimensions, Descr and Product in that order </P><P>then add just one expression as follows</P><P>aggr(sum ( Amount),Descr,Product) </P><P></P><P>after that just drag with the mouse the product (actually click on product without releasing the mouse) on top of the expression (the numeric values) and that's it.</P></BODY></HTML> Fri, 09 Jan 2015 03:37:27 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758377#M269884 2015-01-09T03:37:27Z Re: Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758378#M269885 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Thanks again..</P><P></P><P>Sorry...Its not getting...</P><P></P><P>Sub2u</P></BODY></HTML> Fri, 09 Jan 2015 04:14:15 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758378#M269885 2015-01-09T04:14:15Z Re: Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758379#M269886 <HTML><HEAD></HEAD><BODY><P>This is because you are using a personal edition of Qlikview.</P><P></P><P>So follow this step.</P><P></P><P>Create a pivot table, then,</P><P></P><P>in dimension:</P><P>1. Desr</P><P>2. Product</P><P></P><P>in expression:</P><P>sum(Amount)</P><P>Then say OK.</P><P>After this click on desr field on the chart and keep the left mouse pressed and drag it on the top of Amount field.</P><P></P><P><IMG src="https://community.qlik.com/" /></P><P></P><P>Regards</P><P>KC</P></BODY></HTML> Fri, 09 Jan 2015 04:40:25 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758379#M269886 jyothish8807 2015-01-09T04:40:25Z Re: Need help with Pivot https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758380#M269887 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Is this you needed??</P><P></P><P><IMG class="image-1 jive-image" src="https://community.qlik.com/legacyfs/online/74940_pastedImage_0.png" style="max-width: 1200px; max-height: 900px;" /></P><P>Regards,</P><P>Kavita</P></BODY></HTML> Fri, 09 Jan 2015 07:50:53 GMT https://community.qlik.com/t5/QlikView/Need-help-with-Pivot/m-p/758380#M269887 kavita25 2015-01-09T07:50:53Z