when I export values to excel from straight table I see additional rows

[#1]

Hi Everyone,

I am trying to export values from pivot table to excel but I end up getting extra rows in my exported excel for example

I have a fields called Project Number and Person_Responsible named Edward who has multiple project numbers,

when I am exporting values from the Pivot Table in qlikview to excel , I see redundant rows in excel like extra project numbers for that person responsible that are not present in the datasource also not present in the pivot table in qlikview

Can someone please provide me some inputs on this, is there a way to resolve this?

Thanks in advance

[pover]

Hi Anusha,

When you export a Qlik pivot table to Excel no cells will be merged so values will be repeated.  There's no real way to get around it.

Karl

[#3]

Can I use a vb script in a button with run a macro action, if so could you please provide me a script I tried some of the scripts from community nothing helped

Appreciate your help

[whiteline]

Hi.

Right click -> Copy ->Full table -> Paste into Excel.

This way the cells are merged.

[aveeeeeee7en]

Hi Anusha

It's a Limitation in Qlikview.

You can use Macro for this thing

or  As Whiteline said, you can simply right click on Any chart > Click on Copy to Clipboard > Full Table > Open Excel sheet and paste the copied Table. After doing this you can do table formatting from excel.

See the Attached.

Regards

Aviral Nag

[#6]

Nag,

I have used a VB script

Sub exportExel

set ExcelSheetApp = CreateObject("Excel.Application")

ExcelSheetApp.Visible = false

set ExcelWB= ExcelSheetApp.Workbooks.Add

ExcelWB.Sheets(1).name = "QV-Export"

set XLSheet = ExcelWB.Worksheets(1)

set QVData = ActiveDocument.GetSheetObject("CH230")

set XLSheet = ExcelWB.Worksheets(1)

QVData.CopyTableToClipboard true

XLSheet.Paste XLSheet.Range("A1")

ExcelWB.SaveAs "C:\Users\EANUMUS\Desktop\files\cc.xls", 51

ExcelWB.Close

ExcelSheetApp.Application.Quit

End Sub

Using a button – Run Macro Action, but when I click on the button nothing happens,

I have enabled all the system access and give system access to module script in change module security, but why isn’t the macro runs when I click on the button , I even treid calling at script level,

Is it due security issues, does my userid associated with qlikview needs to have some sort of permissions?

Appreciate your help

[aveeeeeee7en]

Hi Anusha

Your Macro is working fine on my System.

I think you're missing something.

You don' need any permissions to Run Macro on your Developer System.

You just to make following Settings in Macro Edit Module:

1) Requested Module Security - System Access

2) Current Local Security - Allow System Access

and these 2 settings you have done as you've said in your latest Post.

But if you have to Make Macros to Run on Server side than you have to make some settings:

See the Attachment for it - "Macro Settings on Server".

Read this post:

Change Macro security to allow System Access

See the Attachment for Macro Pivot Table Export.

If possible, kindly attach your Qvw.

Regards

Aviral Nag

[#8]

Please find this dummy qvw I have created to show what I am trying to do , correct me if I am missing something

[aveeeeeee7en · Accepted solution]

I have seen your Qvw.

The Macro Name was written wrong. You have written      export        but it should be       exportExel.

The starting line of macro starts  with   "Sub" and the name written after it, is the Macro Name

eg. Sub exportExel

__________

_________

End Sub

Here exportExel is the Macro Name.

See the changes you have to made in the images attached.

Below is the corrected Qvw. Just Run that on your system. It will work fine.

Regards

Aviral Nag

[aveeeeeee7en]

Have you tried the Above Attachment.