Qlikview Macro

[samuel_brierley]

Hi all,

first of all thanks for any help.

im writing a simple export macro and im not sure of how things work within qlikview Macro wise. ill write what I can as if this was word and highlight the qlikview parts that I don't know.

sub export

dim report as date

dim month as string

dim year as string

dim last month as string

report = inputbox("put in report date, 'dd/mm/yyyy')

month = month(report)

year = year(report)

lastmonth  = DateAdd("m", -1, month)

filter chart X on month

ActiveDocument.GetSheetObject("X").exportBitmapTofile blah/blah.png"

Clear all filters

hope that makes sense thanks

[Clever_Anjos]

try this: Re: Macro for exporting object as image?

[samuel_brierley]

unfortunately this doesnt meet the requirements. but thanks for the response.

if you look i have the code to export the chart its filtering the chart on the month/year that i cant do in the macro.

[Clever_Anjos]

Actually you don´t filter a graph, but a field

ActiveDocument.Fields("z").SelectValues "201501"

will filter the data related to 201501