chart wildcard in macro

[#1]

Hi,

sub SalesButton
ActivateButton("BU01")
DeactivateButton("BU02")
DeactivateButton("BU03")
DeactivateButton("BU04")
DeactivateButton("BU05")
ActiveDocument.Variables("vButton").SetContent "sum(Sales)",true
SetPeriodSalesNumberFormat "CH320","Money" 
end sub

I have been using this macro with buttons to switch between Sales, Units, Cost of Goods etc on a report. E.g. hit the sales button and sales are displayed, hit the units button and sales change to units etc,  but the macro is limited to one chart i.e. CH320.

Is there a way to add a wildcard here so it changes all the charts on a page to sales or units etc?

Thanks

David

[danielrozental]

No, but you can cycle through all charts in a sheet using API functions and methods.

[#3]

sub SalesButton
ActivateButton("BU01")
DeactivateButton("BU02")
DeactivateButton("BU03")
DeactivateButton("BU04")
DeactivateButton("BU05")
ActiveDocument.Variables("vButton").SetContent "sum(if((Sales)>1,Sales)) + sum(Sales2) + sum(Sales3)",true
SetPeriodSalesNumberFormat "CH1","Money"
SetPeriodSalesNumberFormat "CH2","Money"
SetPeriodSalesNumberFormat "CH3","Money"
SetPeriodSalesNumberFormat "CH4","Money"
SetPeriodSalesNumberFormat "CH5","Money"
SetPeriodSalesNumberFormat "CH6","Money"
SetPeriodSalesNumberFormat "CH7","Money"
SetPeriodSalesNumberFormat "CH8","Money"
SetPeriodSalesNumberFormat "CH9","Money"
SetPeriodSalesNumberFormat "CH10","Money"
SetPeriodSalesNumberFormat "CH11","Money"
SetPeriodSalesNumberFormat "CH12","Money"
SetPeriodSalesNumberFormat "CH13","Money"
SetPeriodSalesNumberFormat "CH14","Money"
SetPeriodSalesNumberFormat "CH15","Money"
SetPeriodSalesNumberFormat "CH16","Money"
SetPeriodSalesNumberFormat "CH17","Money"
SetPeriodSalesNumberFormat "CH18","Money"
SetPeriodSalesNumberFormat "CH19","Money"
SetPeriodSalesNumberFormat "CH20","Money"
SetPeriodSalesNumberFormat "CH21","Money"
SetPeriodSalesNumberFormat "CH22","Money"
SetPeriodSalesNumberFormat "CH23","Money"
SetPeriodSalesNumberFormat "CH24","Money"
SetPeriodSalesNumberFormat "CH25","Money"

end sub 

I have it updating all of the reports each time by just listing them.

Is there an easier and faster way? It takes about 1 second per report.

I am a DIY Qlikview user so API's are possibly above my level of experise.

Thanks

David