topic Re: Working with Macros in QlikView

Working with Macros

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

Hi all, I am new to working with Macros and encountering a few difficulties.

I have created various pivot tables that need to run via a Macro. The Macro works, it exports my pivot tables into an excel workbook which is perfect.

However, I am unable to filter through my data once the macro has exported my tables into excel.

For example I have a column called GL Group and in GL Group I have 15 records that fall under the category cash but when I search for cash it only returns 1 record and not 15.

Please help

Re: Working with Macros

m_woolf — Fri, 10 May 2019 17:33:54 GMT

When you export your pivottable to excel, it probably shows your Cash category as one big merged cell. You can either write macro code to unmerge the cells and copy the "cash" into each cell, or you can change the way you export the pivottable.

If you use CopyToClipboard|FullTable and then paste into Excel, I believe it will automatically fill all the "Cash" cells instead of merging them.

Re: Working with Macros

Mimi — Mon, 13 May 2019 10:45:06 GMT

Hi Mwoolf,

Thank you for responding.
"If you use CopyToClipboard|FullTable and then paste into Excel, I believe it will automatically fill all the "Cash" cells instead of merging them." - When I copy the table over to excel it still does not give the desired result.

How can I change the way I export the pivottable?
Can you send an example of the macro code to unmerge the cells?