topic Re: Exporting a Bar chart like a pivot table in QlikView

Exporting a Bar chart like a pivot table

Tue, 11 Feb 2014 12:37:59 GMT

Hi,

I have a bar chart, when i export this chart i get data in below format in xls

And desired format is :

Please find the attached test report for more details.

Thanks.

Re: Exporting a Bar chart like a pivot table

luis_pimentel — Tue, 11 Feb 2014 12:44:14 GMT

Exporting the pivot table you also have is not an option? That way it works fine.

Re: Exporting a Bar chart like a pivot table

Tue, 11 Feb 2014 12:49:45 GMT

No .. Bar chart needs to export in that way..

Re: Exporting a Bar chart like a pivot table

giakoum — Tue, 11 Feb 2014 12:53:12 GMT

Create a button that says "Export Bar Chart" but instead export the pivot. Who will know?

Otherwise you will have to create a macro to do so, something like :

SUB Excel

set obj = ActiveDocument.GetSheetObject( "CH01" )

w = obj.GetColumnCount

if obj.GetRowCount>1001 then

h=1000

else h=obj.GetRowCount

end if

Set objExcel = CreateObject("Excel.Application")

objExcel.Workbooks.Add

objExcel.Worksheets(1).select()

objExcel.Visible = True

set CellMatrix = obj.GetCells2(0,0,w,h)

column = 1

for cc=0 to 8

objExcel.Cells(1,column).Value = CellMatrix(0)(cc).Text

objExcel.Cells(1,column).EntireRow.Font.Bold = True

column = column +1

c = 1

r =2

for RowIter=1 to h-1

for ColIter=0 to 8

objExcel.Cells(r,c).Value = CellMatrix(RowIter)(ColIter).Text

'msgbox(CellMatrix(RowIter)(ColIter).Text)

c = c +1

r = r+1

c = 1

END SUB

But I really do not see why.....

Re: Exporting a Bar chart like a pivot table

Tue, 11 Feb 2014 13:06:51 GMT

Good trick .. but they dont want to have any button..

Re: Exporting a Bar chart like a pivot table

ashwanin — Tue, 11 Feb 2014 13:24:38 GMT

Hi Pallavi,

Are you using any macro to export this?

or you are just sending it send to excel option.

If its 2nd option then from Fast Change,change the Bar chart to Pivot Graph. and then do send to excel, which was already in your QV document. I know its not a proper way, but you will get the desired output.

Re: Exporting a Bar chart like a pivot table

Wed, 12 Feb 2014 05:31:59 GMT

Hi,

I am using send to excel option. changing Bar chart to pivot and export it option is not available to me .

My requirement is to export Bar chart to mentioned xls format using send to excel option.

Re: Exporting a Bar chart like a pivot table

sujeetsingh — Wed, 12 Feb 2014 05:53:19 GMT

Pallavi,

see this

Re: Exporting a Bar chart like a pivot table

Anonymous — Wed, 12 Feb 2014 06:15:49 GMT

Can you use the quick change property to allow the user to change the object from a Bar to a Pivot table. Then they can format it as desired and export to excel.

This is standard functionality and therefore requires no coding.

Re: Exporting a Bar chart like a pivot table

ashwanin — Wed, 12 Feb 2014 07:03:46 GMT

HI Pallavi,

It was available in your QV Application.

First click on fast change (Right hand from the send to excel option at chart) and then do Send to excel and you are doing. It will provide you the desired output.

Re: Exporting a Bar chart like a pivot table

Wed, 12 Feb 2014 07:11:33 GMT

Hi Ashwani,

I know fast change option is available. But can we have it without using any button or fast change option?

If no then i need to go with any of these available options..