topic Re: How to split data in to excel from table box? in QlikView https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653265#M1066067 <HTML><HEAD></HEAD><BODY><P>May be no such option in QlikView.</P></BODY></HTML> Tue, 09 Sep 2014 10:45:17 GMT vardhancse 2014-09-09T10:45:17Z How to split data in to excel from table box? https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653259#M1066061 <HTML><HEAD></HEAD><BODY><P><BR />Hi,</P><P></P><P>Please can anyone help me. Please see attached. This is sample three records. All I need when I am sending data to excel based on Address1 the data should be splited in multiple sheets in same workbook.</P><P></P><P>For eg: In attached there are three Address1 I,e </P><P></P><P>2 Jury Street<BR />3 Agalthar<BR />67 Shakespear street </P><P></P><P>when I send to excel the data which is in 2 Jury Street should be in one sheet , 3 Agalthar data should be in next sheet and 67 Shakespear street data in the next sheet and so on.</P><P></P><P>Please let me know can this be done.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 09 Sep 2014 10:11:51 GMT https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653259#M1066061 2014-09-09T10:11:51Z Re: How to split data in to excel from table box? https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653260#M1066062 <HTML><HEAD></HEAD><BODY><P>Please see attached qvw and the output file.</P></BODY></HTML> Tue, 09 Sep 2014 10:12:22 GMT https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653260#M1066062 2014-09-09T10:12:22Z Re: How to split data in to excel from table box? https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653261#M1066063 <HTML><HEAD></HEAD><BODY><P>Could anyone please help me in this. I have been trying this since so many days and I am really struggling with this. Please help me.</P></BODY></HTML> Tue, 09 Sep 2014 10:28:25 GMT https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653261#M1066063 2014-09-09T10:28:25Z Re: How to split data in to excel from table box? https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653262#M1066064 <HTML><HEAD></HEAD><BODY><P>I think there is no direct option in QlikView.</P><P></P><P>Some kind of possibility using some macros for button</P></BODY></HTML> Tue, 09 Sep 2014 10:37:34 GMT https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653262#M1066064 vardhancse 2014-09-09T10:37:34Z Re: How to split data in to excel from table box? https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653263#M1066065 <HTML><HEAD></HEAD><BODY><P>Hi</P><P></P><P>or you can use NPrinting</P><P><A href="http://www.vizubi.com/nprinting/" title="http://www.vizubi.com/nprinting/">NPrinting - Vizubi: Office and HTML Report Creation and Distribution Software</A></P><P></P><P>Regards</P><P>Padma</P></BODY></HTML> Tue, 09 Sep 2014 10:43:13 GMT https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653263#M1066065 qlikoqlik 2014-09-09T10:43:13Z Re: How to split data in to excel from table box? https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653264#M1066066 <HTML><HEAD></HEAD><BODY><P>Thanks. I tried with macro. But macro sending data to single sheet with all addresses which is not the expected result.</P></BODY></HTML> Tue, 09 Sep 2014 10:43:41 GMT https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653264#M1066066 2014-09-09T10:43:41Z Re: How to split data in to excel from table box? https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653265#M1066067 <HTML><HEAD></HEAD><BODY><P>May be no such option in QlikView.</P></BODY></HTML> Tue, 09 Sep 2014 10:45:17 GMT https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653265#M1066067 vardhancse 2014-09-09T10:45:17Z Re: How to split data in to excel from table box? https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653266#M1066068 <HTML><HEAD></HEAD><BODY><P>Hi!</P><P></P><P>There isn't option for that in QV.</P><P></P><P>Very complex solution:</P><P>Make a report and complex macro. It will take time and won't work very well.</P><P></P><P>Simple solution:</P><P>Buy NPrinting. It's fast and works. It costs something.</P><P></P><P>Br,</P><P>Miikka</P><P>Climber Finland Oy</P></BODY></HTML> Tue, 09 Sep 2014 14:27:16 GMT https://community.qlik.com/t5/QlikView/How-to-split-data-in-to-excel-from-table-box/m-p/653266#M1066068 miikkaqlick 2014-09-09T14:27:16Z