topic Qlikview Macro in QlikView

Qlikview Macro

samuel_brierley — Thu, 06 Aug 2015 14:06:43 GMT

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

Re: Qlikview Macro

Clever_Anjos — Thu, 06 Aug 2015 14:11:05 GMT

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

Re: Qlikview Macro

samuel_brierley — Thu, 06 Aug 2015 15:11:02 GMT

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.

Re: Qlikview Macro

Clever_Anjos — Thu, 06 Aug 2015 15:55:41 GMT

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

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

will filter the data related to 201501