Export to Excel into multiple sheets

[#1]

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

[Bill_Britt]

Hi,

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

Bill

[MayilVahanan]

Hi

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

[#4]

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

[MayilVahanan]

Hi,

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

[#6]

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.

[MayilVahanan]

HI

PFA

Hope it helps