Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
pivot table export to excel expand option not working in excle
You need to expand the table fully before exporting to Excel. But the functions in QV to expand, drag&drop dimensions etc. isn't supported in Excel.
You can perhaps use the functions Pivot Table or Autofilter in Excel to create a "similar" enviroment
Same look and feel like qlikview pivot table as excel format(including
expand option)
No but the Autofilter function in Excel, is quite simular to the expand option (but not so fancy) http://www.contextures.com/xlautofilter01.html
treeview is possible in Excel
