topic Applying Theme with Macro in QlikView

Applying Theme with Macro

Tue, 28 Jun 2011 09:54:55 GMT

Hi,

Can any one explain to apply theme with the help of a button using macro for both sheet object and sheet..

Regards,

Guruprasth M

Applying Theme with Macro

kaushiknsolanki — Tue, 28 Jun 2011 11:20:15 GMT

Hi,

Yes there is a macro code by which you can achieve this. They are.

Document - ActiveDocument.ApplyTheme "A:\Forest.qvt"

Sheet - ActiveDocument.ActiveSheet.Applytheme "A:\Forest.qvt"

Object - set obj = ActiveDocument.GetSheetObject("CH01")

obj.ApplyTheme "Forest.qvt"

Regards,

Kaushik Solanki

Applying Theme with Macro

Wed, 29 Jun 2011 04:20:24 GMT

Hi,

Thanks, but it is applied before we click the button..is there any option for making the theme deactivate and then by clicking the button so the theme can be re applied??

Regards,

Guruprasath M

Applying Theme with Macro

kaushiknsolanki — Wed, 29 Jun 2011 08:00:09 GMT

Hi,

How did you use the above statements.

Can you please upload the qvw file.

Regards,

Kaushik Solanki

Applying Theme with Macro

Thu, 30 Jun 2011 04:40:54 GMT

Hi,

Ya sure I will attach my file..

Thanks,

Guruprasath M