Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

paulyeo11
Valued Contributor II

Macro can it be able to replace by other ?

Hi All

How to replace below macro to not using macro:-

sub CR01()

set chart = ActiveDocument.GetSheetObject("CH1")

set p = chart.GetProperties

set NoColumns = ActiveDocument.Variables("vNoOfColumns")

set NoRows = ActiveDocument.Variables("vNoOfRows")

    p.ChartProperties.TrellisProperties.Columns= NoColumns.GetContent.String

    p.ChartProperties.TrellisProperties.Rows= NoRows.GetContent.String

    chart.SetProperties p

end sub

1 Solution

Accepted Solutions

Re: Macro can it be able to replace by other ?

Hi,

Sorry that functionality can not be achieved without macro and Macro's are not supported on Ajax.

Regards,

Kaushik Solanki

6 Replies

Re: Macro can it be able to replace by other ?

Hi,

Paul, why dont you use trellis chart instead of the macro.

If you want functionality where if you click on button then you want chart to convert into trellis, then try using two charts one is hidden and other is visible depending on variable.

Regards,

Kaushik Solanki

paulyeo11
Valued Contributor II

Re: Macro can it be able to replace by other ?

Hi Kau

I already using the trills chart. i just want apply this in QS , as QS not support macro.

Still not understand why QS not support button using action.

Paul

Re: Macro can it be able to replace by other ?

Hi,

Your application has section access.

Kindly give username and password of admin to open the application.

Regards,

Kaushik Solanki

paulyeo11
Valued Contributor II

Re: Macro can it be able to replace by other ?

Hi Kau, I just want to tell you the macro is for trellis chart. because you asking me to make use of trellis chart. so i not quite understand you.

trillis chart.png

Re: Macro can it be able to replace by other ?

Hi,

Sorry that functionality can not be achieved without macro and Macro's are not supported on Ajax.

Regards,

Kaushik Solanki

MVP
MVP

Re: Macro can it be able to replace by other ?

Hi,

You can set Trellis option Rows and Columns here.  If you want to set it automatically then you have to use Macro for this.

Trellis.png

Regards,

Jagan.

Community Browser