topic Re: Export to Excel into multiple sheets in QlikView

Export to Excel into multiple sheets

Thu, 21 Nov 2013 20:30:09 GMT

Hi,

I have a straight table in qlikview like below.

Is it possible to export the data to a spread sheet into multiple sheets based on the first column. In the example below it should go to 4 different sheet in the excel report o/p. Where there are 5 market categories it should go to 5 different sheets?

Thank you!

MarketCategory	ProductID	Date	Header 4	Header 5
A	dfgert	20010101	qwiojr	uinrtjn
B	sdokm	20020101	fjiwerm	yugrewbur
C	mrrytr	20030101	nionnun	rtuhrtn
D	ghhj	20040101	mihret	wuiowrtjn

Re: Export to Excel into multiple sheets

Bill_Britt — Thu, 21 Nov 2013 20:32:57 GMT

Hi,

I have never seen that done before and would say there isn't an easy way to do it.

Bill

Re: Export to Excel into multiple sheets

MayilVahanan — Thu, 21 Nov 2013 20:35:15 GMT

You can use macro to achieve this. But its very difficult process.

Re: Export to Excel into multiple sheets

Thu, 21 Nov 2013 20:39:47 GMT

In that case can we create 4 or 5 different straight tables dynamically depending on the number of market categories?

Re: Export to Excel into multiple sheets

MayilVahanan — Thu, 21 Nov 2013 20:48:12 GMT

Hi,

Yes. But can i know why this required. instead of viewing all the market category in one place?

Re: Export to Excel into multiple sheets

Thu, 21 Nov 2013 20:54:07 GMT

That is how the business team gives their report to the upper management. Different market categories in separate sheets. And they spend quite some time in doing all these manual work. they have 8-10 sheets and some pivot and overall reporting.

Re: Re: Export to Excel into multiple sheets

MayilVahanan — Thu, 21 Nov 2013 21:32:54 GMT

PFA

Hope it helps