Export to excel - Split row into multiple columns

[xiuur2508]

Hello Qlik community

I have a little problem with function export to excel.

So i have a field, with 1500 rows. When i export to excel, i have only one column, with all data.

So it's a waste of paper. I need to export on multiple columns.

I don't want to use Nprinting ( cuz we have to many report )

Thx

[engishfaque]

Dear Florian,

You can generate your file through script in CSV file format with your required delimiter, so here is the way,

STORE YourTableName into (text, delimiter is ',');

Kind regards,

Ishfaque Ahmed

[xiuur2508]

Hello, thx for the answer,

But i don't know what to do with the csv. I need to have column on the export excel.

Have a nice day

[engishfaque]

Dear Florian,

It would be nice if you share share your QVW.

Kind regards,

Ishfaque Ahmed

[xiuur2508]

It's not about the qvw, but i joined it.

So i have 100 rows, when i click on export to excel, i have only one column.
If i want to print it, i need 4 sheet of paper.

So i need to have 4 columns to print it on one sheet.

Sorry i have a bad english ^^ but i hope you understand what i need to do.

[engishfaque]

Dear Florian,

Just clear me, do you have listed below scenario.

You have a object (Table Box) which is actually consist on 100 data rows or more. So, whenever you click on "Send to Excel" or "Print" (Special Icons) it always print on more than one page. A lot of blank space exist/available on each sheet. So you do not want to waste paper and you want to brake 100 data rows or more data rows into multiple columns as the paper can be save and most of the data printed on the same paper.

Kind regards,

Ishfaque Ahmed

[xiuur2508]

Yep that's what i want ^^

example:

Column1: 0->25 rows

Column2: 25->50 rows

Column3: 50->75 rows

Column4: 75->100 rows