Aggregator

[XenoG]

I'm using a pivot type of jqptPivotUI and am struggling to find a way to programmatically select the AggregatorType and the value in the dropbox that appears below the AggregatorType dropbox for some aggregator types. e.g. I would like the AggregatorType dropbox to default to jqpaIntSum and the dropbox below the AggregatorType to automatically select one of the json types that I specify at run-time. Furthermore, it would be nice to be able to hide some of the Aggregator types. as I don't think all are relevant for my application.

Many thanks in advance for your help again.

Richard

[Alexander Bulei]

Hi XenoG,

For extended customization, you need create you own js locale file.

Please extract the rar to "wwwroot/jq/pivottable", and them on form create:

delphi code

procedure TFORMTEST.IWAppFormCreate(Sender: TObject);
begin
  IWCGJQPivot.JQPivotLocale.Filename:= 'pivot.es.extended.js';
  IWCGJQPivot.JQPivotLocale.JSonName:= 'esExtended'; // CHECK THE FILE FOR THIS NAME
  IWCGJQPivot.JQPivotUIOptions.AggregatorName:= jqpaIntSum; // DEFAULT SELECTED
end;

Best Regards.

[XenoG]

Many thanks Alexander. Your suggestion works really well. The only thing I can't figure out is how to auto-select the value in the combobox that appears when the aggregator is set to IntegerSum. I'd like to set the index of this combobox programmatically, so my users don't need to select from this dynamically created combobox. I've attached images of the combobox before and after I manually select an item.

Before manual selection

Heatmap Unselected.png

After manual selected

Heatmap Visitors.png

Thanks again for all your help.

Richard

[Alexander Bulei]

Hi XenoG,

I'd like to set the index of this combobox programmatically, so my users don't need to select from this dynamically created combobox.

Unfortunately, at this moment, there is no way to select the value.

I will check what we can do, to make available that functionality

Best Regards.

[XenoG]

Thanks Alexander. I appreciate the support you've given.

[Alexander Bulei]

Hi XenoG,

Will be available in next beta build.

Best Regards.