Need Help in qlikview macro to send qlikview chart as image

[tripatirao]

Dear all,

I need help with macro code that will save my qlikview charts as image by looping a field value.

I have attached  my source code  and qlikview file.

I have explained my requirement in textbox Please check. and help me.

Regards

Tripati

[trdandamudi · Accepted solution]

Please see the attached or the solution and hope this helps..

[tripatirao]

Dear Thirumala,

Thanks for your Reply.

The above macro is working for the charts which does not have calculated condition.

In my real application I have calculated condition.

I have to select Fiscal_Year,FiscalMonth_Name,Region to show value on the chart.

I have attached the charts for your reference please check.

Fiscal_Year Value like 2011,2012,2013,2014..........

FiscalMonth_Name  value like Jan,Feb,Mar............

FUNCTION ExportObjectToPNG(ObjID, fName)

  ActiveDocument.GetSheetObject(ObjID).ExportBitmapToFile fName

END FUNCTION

SUB ExportChartByRegionListboxValues

  DIM fname, value, filePath, timestamp

  SET Doc = ActiveDocument

  Doc.Fields("Fiscal_Year").Select Doc.Evaluate("max(Fiscal_Year)")

  Doc.Fields("FiscalMonth").Select Doc.Evaluate("max(FiscalMonth)")

  FieldName = "Region"

  SET Field = Doc.Fields(FieldName).GetPossibleValues

  FOR index = 0 to Field.Count-1

  Doc.Fields(FieldName).Clear

  Doc.Fields(FieldName).SELECT Field.Item(index).Text

  fileName = Field.Item(index).Text & ".png"

  ExportObjectToPNG "CH171", "E:\BSC_Test\Excel\" & fileName

  NEXT

  Doc.Fields(FieldName).Clear

END SUB

[trdandamudi]

If you have calculated conditon, then you need to select the conditions that you need and then click on the "Export" button. But for this to work, you should not loop thru the list box values in the macro. Hope this helps,,,

[tripatirao]

Hi Thirumala,

Macro is working fine now for me.

Now my requirement is how to send these image into single ppt slide by using macro

Regards

Tripati

[tripatirao]

Hi Thirumala,

Can you help me with the code.

Regards

Tripati

[trdandamudi]

Sorry, was not able to login into the community as I was busy with work.. I think the below link will get you what you are looking for. Hope this helps,,,

Automated PowerPoint Presentation Extraction