topic Re: Pivot table drawing in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454321#M169518 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The logic doesn't lies within the Excel sheet. It doesn't matter if the data comes from an excel or Text file. If you see within the application I have kept all values as one expression and within the pivot I just have dragged the dimension and expressions. If possible share a sample of your application. </P><P>Thanks...</P></BODY></HTML> Mon, 10 Jun 2013 08:55:10 GMT amars 2013-06-10T08:55:10Z Pivot table drawing https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454318#M169515 <HTML><HEAD></HEAD><BODY><P>Hello Evryone,</P><P>I am facing a problem here.First please go through my attachment.Here the 'Total Number' row contains the absolute number, but the row number 3 onwards contains the percentage data.These both data are to be shown in a same field at a time.</P><P>How this kind of data representation can be possible?</P><P>Please answer this problem this is urgent for my job.</P><P></P><P>Thank you all.</P></BODY></HTML> Mon, 10 Jun 2013 06:05:11 GMT https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454318#M169515 2013-06-10T06:05:11Z Re: Pivot table drawing https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454319#M169516 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Check the attached file. You can get some rough idea on how to do this. </P></BODY></HTML> Mon, 10 Jun 2013 07:06:57 GMT https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454319#M169516 amars 2013-06-10T07:06:57Z Re: Pivot table drawing https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454320#M169517 <HTML><HEAD></HEAD><BODY><P>Thank you Amars for your reply. But this woiuld not solve the purpose as the data is not maintained in the excell file it is rather maintained in the text format and all the data fetched from these txt file. Therefore I have no chance to modify the data within the excell as you have done.</P><P>Please show me any other way out regarding this problem.</P><P></P><P>Thanking You</P></BODY></HTML> Mon, 10 Jun 2013 08:10:18 GMT https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454320#M169517 2013-06-10T08:10:18Z Re: Pivot table drawing https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454321#M169518 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>The logic doesn't lies within the Excel sheet. It doesn't matter if the data comes from an excel or Text file. If you see within the application I have kept all values as one expression and within the pivot I just have dragged the dimension and expressions. If possible share a sample of your application. </P><P>Thanks...</P></BODY></HTML> Mon, 10 Jun 2013 08:55:10 GMT https://community.qlik.com/t5/QlikView/Pivot-table-drawing/m-p/454321#M169518 amars 2013-06-10T08:55:10Z