Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
May 18th 10AM ET, Live Chat, bring your QlikView questions. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Export to excel

Hi Team,

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.

Please do the needful.

Thanks & Regards,

AK

5 Replies
Frank_Hartmann
Master II
Master II

sona_sa
Creator II
Creator II
Author

Hi Frank,

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.

Hope you got my points.

Regards,

Amit Kumar

Victor_Alumanah
Creator
Creator

1 option is to export it to Excel and create a pivot table, please see attached.

While we teach we learn
sona_sa
Creator II
Creator II
Author

Hi Victor,

Thanks for the same. But it is manually done in Excel. Can you describe the steps.

Also I want to know is there any possibilities of Macro to do the same through from QlikView while exporting the data to excel.

Regards,

AK

Victor_Alumanah
Creator
Creator

I don't know if it is possible to do this using a macro, but below are the manual steps to recreate in excel.

 

  1. Select all data(CTRL +A)
  2. On menu select Insert, then Pivot
  3. A prompt called “Create pivot table” will appear, click ok
  4. A new sheet will appear, click on cell A3
  5. On the right of the screen will be a list of fields
  6. Drag “Count” to bottom right cell called values
  7. Drag all the others in the right order to “Row labels” (near where you put count)
  8. Right click pivot table and select Pivot table options
  9. On the the display tab select the option Classic pivot table layout
  10. Right click cell A7 and unselect Subtotal, and then do the same for the other columns(B7 e.t.c)
While we teach we learn