topic chart wildcard in macro in QlikView

chart wildcard in macro

Mon, 19 Sep 2011 05:07:39 GMT

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

chart wildcard in macro

danielrozental — Mon, 19 Sep 2011 21:56:57 GMT

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

Re: chart wildcard in macro

Tue, 20 Sep 2011 03:23:43 GMT

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