Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone. Is there a way to create a button that expands all fields in a table and then exports that table to Excel automagically? Would someone please walk me through this process? I really appreciate it. Thank you.
When you say "expands all fields in a table", I assume it is a pivottable.
From the API Guide:
set chart = ActiveDocument.Activesheet.CreatePivotTable
set gp = chart.GetProperties
gp.TableProperties.PivotAlwaysFullyExpanded = true
chart.SetProperties gp
You could write a macro that would set the PivotAlwaysFullyExpanded property to true.
Then export to Excel.
Then set the PivotAlwaysFullyExpanded property to false.
When you say "expands all fields in a table", I assume it is a pivottable.
From the API Guide:
set chart = ActiveDocument.Activesheet.CreatePivotTable
set gp = chart.GetProperties
gp.TableProperties.PivotAlwaysFullyExpanded = true
chart.SetProperties gp
You could write a macro that would set the PivotAlwaysFullyExpanded property to true.
Then export to Excel.
Then set the PivotAlwaysFullyExpanded property to false.
Thank you Michael. I was going to implement your suggestion but during a meeting yesterday was told that macros in QlikView are very unstable over the internet. As I was wanting to publish my app to QV Server, I'm not sure that it would be worth the time to put a macro into my app only for it to be faulty because of the net.