topic Re: Unmergerd cells while export to excel in QlikView

Unmergerd cells while export to excel

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I am exporting the pivot table data into excel by using Vb Script and it exporting the data into excel successfully, Here i need to unmerge the cells.

For example:

Here Group No is Merged Center i want to Unmerge that cell.

My Current Result:

Group No	Name
1	aaa
	bbb
	ccc
	ddd
2	eee
	fff
	ggg
3	hhh
3	iii

My Expected Result:

I need the below table result while export it into excel

Group No	Name
1	aaa
1	bbb
1	ccc
1	ddd
2	eee
2	fff
2	ggg
3	hhh
3	iii

Re: Unmergerd cells while export to excel

effinty2112 — Sat, 09 Sep 2017 11:07:36 GMT

Hi Yuvari,

The simple command : right mouse button click Send To Excel will unmerge the cells and paste the data into a new excel file.

Regards

Andrew

Re: Unmergerd cells while export to excel

Anonymous — Sat, 09 Sep 2017 11:33:12 GMT

Hi Andrew,

I need to do it manually everyday so now am going to automate this process after dashboard refresh the table data will export into excel and placed into target location.

Re: Unmergerd cells while export to excel

rohitraut — Sat, 09 Sep 2017 16:19:15 GMT

Hello Yuvaraj,

Try this ,

Set vDate = date(today());

Group:

load

Group No ,

Name

Form abc.qvd;

Store Group into E:GroupFolder(here put your target location path)\GroupInfo$'(vDate)'.csv(txt);

Use Nprinting ..

Qlik NPrinting is the reporting platform for QlikView and Qlik Sense. With Qlik NPrinting you can create reports from your QlikView document and Qlik Sense apps and distribute them automatically in a range of standard formats such as PDF, Excel, Word, PowerPoint, and HTML. You can create highly polished PixelPerfect and HTMLreports with built in editors.

How does Qlik NPrinting work?

Qlik NPrinting generates reports that are based on templates created by you, or based on QlikViewand Qlik Sense entities. You can deliver reports at scheduled times or when they are requested by individual users. Final reports are static files that contain copies of the original QlikView and Qlik Sense data as it was at the time the report was generated.

Qlik NPrinting can distribute the workload across multiple multi-threaded engines to ensure high availability and fast performance. All meta-data is saved in a database system that makes it easy to manage backups, and allows multiple developers to work concurrently.

Hope this help!