Applying theme on Click of a Button

Anonymous — Tue, 16 Jun 2015 06:14:46 GMT

Dear All,

I was trying to apply theme on Button click with following Macro Code:

sub applytheme

set theme=ActiveDocument.GetSheetObject("CH01")

theme.ApplyTheme "forest.qvt"

msgbox"Theme Applied"

end sub

I am getting pop up message i.e Theme Applied but no theme on chart object.

Let me know If I am missing something.

Regards,

Balraj

Re: Applying theme on Click of a Button

marcus_sommer — Tue, 16 Jun 2015 10:23:34 GMT

I think the path to the qvt is missing:

...

theme.ApplyTheme "C:\Users\YOURUSER\AppData\Roaming\QlikTech\QlikView\Themes\forest.qvt"

...

or wherever your qvt-files are stored.

- Marcus