How to split data in to excel from table box?

[#1]

Hi,

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.

For eg: In attached there are three Address1 I,e

2 Jury Street
3 Agalthar
67 Shakespear street

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.

Please let me know can this be done.

Thanks.

[#2]

Please see attached qvw and the output file.

[#3]

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.

[vardhancse]

I think there is no direct option in QlikView.

Some kind of possibility using some macros for button

[qlikoqlik]

Hi

or you can use NPrinting

NPrinting - Vizubi: Office and HTML Report Creation and Distribution Software

Regards

Padma

[#6]

Thanks. I tried with macro. But macro sending data to single sheet with all addresses which is not the expected result.

[vardhancse]

May be no such option in QlikView.

[miikkaqlick]

Hi!

There isn't option for that in QV.

Very complex solution:

Make a report and complex macro. It will take time and won't work very well.

Simple solution:

Buy NPrinting. It's fast and works. It costs something.

Br,

Miikka

Climber Finland Oy