I have a pivot table with some 5 Dimension and 1 Expression. Now I want to export the data in excel. I am able to download the excel, But the Expand and collapse option I am missing.
Do we have that type of macro or functionality in QlikView, So we can export the data with expand and collapse option. For more please find the attached QVW. Please share the script in notepad, So I can copy that and use in my QVW.
Thanks for reply, But after exporting the data, I want collapse and Expand option in Excel. Just like what ever we are doing in QlikView. That + and - button, which is available in QlikView Pivot table.