topic How to use pivot table to create a chart in QlikView https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317088#M116970 <HTML><HEAD></HEAD><BODY><P>i have created a pivot table, now they want same pivot data to in line chart format, i have tried converting it to line chart but the chart is not as expected can any one help, OR is there any way that i can&nbsp; use the pivot talbe to create the chart, any help will be appricated</P><P><IMG __jive_id="11633" alt="Picture1.png" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/11633_Picture1.png" width="450" /></P></BODY></HTML> Fri, 24 Feb 2012 10:53:08 GMT 2012-02-24T10:53:08Z How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317088#M116970 <HTML><HEAD></HEAD><BODY><P>i have created a pivot table, now they want same pivot data to in line chart format, i have tried converting it to line chart but the chart is not as expected can any one help, OR is there any way that i can&nbsp; use the pivot talbe to create the chart, any help will be appricated</P><P><IMG __jive_id="11633" alt="Picture1.png" class="jive-image-thumbnail jive-image" src="https://community.qlik.com/legacyfs/online/11633_Picture1.png" width="450" /></P></BODY></HTML> Fri, 24 Feb 2012 10:53:08 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317088#M116970 2012-02-24T10:53:08Z How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317089#M116971 <HTML><HEAD></HEAD><BODY><P> Any help</P></BODY></HTML> Fri, 24 Feb 2012 12:45:23 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317089#M116971 2012-02-24T12:45:23Z How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317090#M116972 <HTML><HEAD></HEAD><BODY><P>Your best bet is to copy the Pivot table so that you don’t lose your data andturn the new Pivot table into a Combo Chart. I would then remove some of thedata and you may have to tweak the display options in the Expressions tab.</P><P>I hope this helps, regards</P><P>Maria</P></BODY></HTML> Fri, 24 Feb 2012 15:55:34 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317090#M116972 2012-02-24T15:55:34Z Re: How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317091#M116973 <HTML><HEAD></HEAD><BODY><P>hi,</P><P></P><P>It's always diffcult to conver data a pivot to chart as it is, as the data in pivot are huge this data in charts will not be as readable as it is pivot.</P><P></P><P>In such cases you can use two dimesnions and both as cyclic group .</P><P></P><P>I have attach a sample application. </P><P></P><P>Deepak</P></BODY></HTML> Fri, 24 Feb 2012 17:35:48 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317091#M116973 deepakk 2012-02-24T17:35:48Z How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317092#M116974 <HTML><HEAD></HEAD><BODY><P> hi Maria,</P><P>I tried doing that bt still i am not getting the desire resulta, the expression which i want on X-axis is dipplayed as legends the chart is in reverse and i tried altering it but still the same</P></BODY></HTML> Mon, 27 Feb 2012 07:46:04 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317092#M116974 2012-02-27T07:46:04Z Re: How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317093#M116975 <HTML><HEAD></HEAD><BODY><P>Deepak's solution works well, but you still have far too much data for onechart and your series have large variances ranging from hundreds to just shortof a million. This amount of data would illegible on any chart.&nbsp; </P><P>I would create three or four charts putting different series of data in each.</P></BODY></HTML> Mon, 27 Feb 2012 09:17:37 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317093#M116975 2012-02-27T09:17:37Z How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317094#M116976 <HTML><HEAD></HEAD><BODY><P>I am using PE version of QV so not able to open Deepak's sample, it would be great if you can reply me wht are u doing or send it in notepad</P></BODY></HTML> Mon, 27 Feb 2012 09:37:45 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317094#M116976 2012-02-27T09:37:45Z How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317095#M116977 <HTML><HEAD></HEAD><BODY><P> Hi Deepak,</P><P>I am not able to open ur sample file, can you tell a brief about it</P></BODY></HTML> Mon, 27 Feb 2012 09:40:25 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317095#M116977 2012-02-27T09:40:25Z Re: How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317096#M116978 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>Can u share sample QV data. </P><P>Also, from that, what inferences you want to draw.</P><P></P><P>I will send methodology to create chart from it.</P></BODY></HTML> Mon, 27 Feb 2012 09:41:58 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317096#M116978 2012-02-27T09:41:58Z Re: How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317097#M116979 <HTML><HEAD></HEAD><BODY><P>Hi Maria,</P><P></P><P>It actually depends on the requirement and in certain cases we have to convince the user that you can view the report in this way.</P><P></P><P></P><P>Hi Mohammed,</P><P></P><P>I have created two cyclic object. In first cycle I have added the 1 and 2 dimension. And in the second I have added</P><P>2and 3 dimension and hence you can have different view of your same data in charts</P><P></P><P></P><P></P><P>Deepak</P></BODY></HTML> Mon, 27 Feb 2012 09:42:55 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317097#M116979 deepakk 2012-02-27T09:42:55Z How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317098#M116980 <HTML><HEAD></HEAD><BODY><P> Hi ravi, i have uploaded the excel in the original post, i have manuplated the data as i can't share the original data, and i dnt want to use cross table to upload the data, becoz i have to use it as it</P></BODY></HTML> Mon, 27 Feb 2012 10:01:19 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317098#M116980 2012-02-27T10:01:19Z How to use pivot table to create a chart https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317099#M116981 <HTML><HEAD></HEAD><BODY><P> Hi Ravi, do you got any way to figure it out</P></BODY></HTML> Mon, 27 Feb 2012 12:01:54 GMT https://community.qlik.com/t5/QlikView/How-to-use-pivot-table-to-create-a-chart/m-p/317099#M116981 2012-02-27T12:01:54Z