topic Re: Bar chart export to excel in QlikView

Bar chart export to excel

vardhancse — Tue, 23 Jun 2015 08:36:45 GMT

Hi,

When i export a bar chart to excel its showing in table format, can please me know is there a option to export into bar chart other than reports/nprinting solutions.

Re: Bar chart export to excel

Tue, 23 Jun 2015 08:44:22 GMT

HI Kandragula..

There is no direct QlikView option which can be enabled to Export Graph into Excel. Alternatively you can achieve this by writing a macro . The macro is as below :-

Sub ExportGraph()
Dim vSheet
Set XLApp = CreateObject("Excel.Application")
XLApp.Visible = TRUE
Set XLDoc = XLApp.Workbooks.Add
vSheet = ""
vSheet = "Sheet1"
ActiveDocument.GetSheetObject("CH26").CopyBitmapToClipboard 'Copy the charts
XLDoc.Sheets(vSheet).Range("A" & 1).Select
XLDoc.Sheets(vSheet).Paste

Set XLDoc = Nothing
Set XLApp = Nothing

End Sub

Hope this will work and let me know..

Regds
Prabakar

Re: Bar chart export to excel

vardhancse — Tue, 23 Jun 2015 08:47:37 GMT

Hi prabhakar,

Trying to create one action based on marco,

Throwing error 'expected end'

Re: Bar chart export to excel

Tue, 23 Jun 2015 08:51:10 GMT

Hi Sasi..

Yes your macro will export the bar chart but the macros are not running in the Qlikview 9.00 version in the Access point.

Since i am trying to do the same thing. Since macros are not working. Need to explore it more and let you know.

Regds

Prabakar

Re: Bar chart export to excel

vardhancse — Tue, 23 Jun 2015 08:54:27 GMT

In order to get image we can get directly in

browser->In browser->Right click(on the required chart)->print->

Graph image will be opened in separate browser window->Image->right click->copy and paste in excel.

we can get as an image in excel

Re: Bar chart export to excel

vardhancse — Tue, 23 Jun 2015 08:56:14 GMT

And more over macros will not work in ajax mode

Re: Bar chart export to excel

Tue, 23 Jun 2015 08:59:02 GMT

Hi ..

So you got the solution for your queries right ?

Regds

Prabakar

Re: Bar chart export to excel

vardhancse — Tue, 23 Jun 2015 09:04:04 GMT

No,

I m looking for direct export of graph to excel not in image format.

Re: Bar chart export to excel

Tue, 23 Jun 2015 09:10:40 GMT

Hi Sasi..

Can you try this once..?

Sub GetChartValues()

Dim NumberOfRows As Integer

Dim X As Object

Counter = 2

' Calculate the number of rows of data.

NumberOfRows = UBound(ActiveChart.SeriesCollection(1).Values)

Worksheets("ChartData").Cells(1, 1) = "X Values"

' Write x-axis values to worksheet.

With Worksheets("ChartData")

.Range(.Cells(2, 1), _

.Cells(NumberOfRows + 1, 1)) = _

Application.Transpose(ActiveChart.SeriesCollection(1).XValues)

End With

' Loop through all series in the chart and write their values to

' the worksheet.

For Each X In ActiveChart.SeriesCollection

Worksheets("ChartData").Cells(1, Counter) = X.Name

With Worksheets("ChartData")

.Range(.Cells(2, Counter), _

.Cells(NumberOfRows + 1, Counter)) = _

Application.Transpose(X.Values)

End With

Counter = Counter + 1

End Sub

Regds

Prabakar

Re: Bar chart export to excel

vardhancse — Tue, 23 Jun 2015 09:20:12 GMT

can please let me know what is the output for the above macro

Re: Bar chart export to excel

Tue, 23 Jun 2015 09:22:54 GMT

HI..

This is to extract the data to excel. The same method can be possible to upload the bar chart to excel. Please try and let me know

Regds

Prabakar

Re: Bar chart export to excel

vardhancse — Tue, 23 Jun 2015 10:11:43 GMT

thanks for your support.

Throwing an error for the macro

Re: Bar chart export to excel

Wed, 24 Jun 2015 10:33:02 GMT

Hi,

You can directly copy your object from qlikview (select object and CTRL+C) and paste in the excel (CTRL+V).

Try this out.

Re: Bar chart export to excel

vardhancse — Wed, 24 Jun 2015 10:34:29 GMT

Hi this can be done only if it was enabled in security tab of the sheet.

And more over I my requirement is not a image i am looking for direct export of bar graph to excel

Re: Bar chart export to excel

Wed, 24 Jun 2015 10:39:26 GMT

Not the image the entire chart object will be copied to the excel.

Re: Bar chart export to excel

vardhancse — Wed, 24 Jun 2015 10:40:52 GMT

yes entire chart will come but it will be in image format not as what we see in our dashboards