Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
paulyeo11
Master
Master

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
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

View solution in original post

6 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
paulyeo11
Master
Master
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

Your application has section access.

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
paulyeo11
Master
Master
Author

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

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

Hi,

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

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!
jagan
Luminary Alumni
Luminary Alumni

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.