Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Applying Theme with Macro

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

4 Replies

Applying Theme with Macro

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

Not applicable

Applying Theme with Macro

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

Hi,

   How did you use the above statements.

   Can you please upload the qvw file.

Regards,

Kaushik Solanki

Not applicable

Applying Theme with Macro

Hi,

          Ya sure I will attach my file..

Thanks,

Guruprasath M

Community Browser