Discussion Board for collaboration on QlikView Scripting.
How to replace below macro to not using macro:-
set chart = ActiveDocument.GetSheetObject("CH1")
set p = chart.GetProperties
set NoColumns = ActiveDocument.Variables("vNoOfColumns")
set NoRows = ActiveDocument.Variables("vNoOfRows")
Go to Solution.
Sorry that functionality can not be achieved without macro and Macro's are not supported on Ajax.
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.
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.
Your application has section access.
Kindly give username and password of admin to open the application.
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.
You can set Trellis option Rows and Columns here. If you want to set it automatically then you have to use Macro for this.