Excel Prob

Tue, 04 Dec 2012 07:32:39 GMT

Dear Friends,

I have a Pivort Table in QV

Wn I ma exporting data from qv to excel data is not showing in the format of pivort

it showing flat data is there any macro for showing data in excel as pivort table

Thanks&Regards,

Ramchandra Reddy.G

08015258712

Re: Excel Prob

Or — Tue, 04 Dec 2012 07:47:56 GMT

I'm not entirely sure what you're trying to do:

1) If you're trying to copy the layout (that is, make the Excel file look like a pivot table, with merged cells) - you can use a simple Copy-paste (copy the table in QV, paste in Excel). Alternatively, see this thread for a macro solution.

2) If you're trying to create an actual Excel pivot table based on a QlikView pivot table - this can't be done directly from QV as far as I know, and it wouldn't make any sense either - you'd be using Excel's pivot table mechanism to aggregate values that have already been aggregated in QV. If you'd like to replicate your QV logic and create a pivot table based on that in Excel, I'd recommend saving the raw data as CSV (when running the script) and reading that with Excel's pivot table mechanism.

Good luck.

topic Excel Prob in QlikView

Excel Prob

Re: Excel Prob