Allow user to change aggregations in a straight table

[#1]

I have a straight table that a user can select which dimensions and metrics will be shown in the straight table. The totals are by the expression. The user would like to switch between a sum and an avg depending on which metrics they choose. Is there an easy way to let them do this since they will not be able to access chart properties? Perhaps a quick toggle?

[MarcoWedel]

just to prove that in most cases there is more than one solution in QlikView:

Transactions:
Load
TransLineID,
TransID,
Pick(Ceil(3*Rand1),'A','B','C') as Dim1,
Round(1000*Rand()*Rand()*Rand1) as Expression1;
Load
Rand() as Rand1,
IterNo() as TransLineID,
RecNo() as TransID
Autogenerate 30;

tabAggregations:
LOAD * INLINE [
    aggregation
    Sum
    Count
    Avg
    Min
    Max
    Only
    Mode
    Concat
    Stdev
    Sterr
    Median
];

hope this helps

regards

Marco

[MarcoWedel]

For independent expressions (e.g. with different parameters) you could also use an island table with selection name and expression fields or a Pick(Match(...)...) combination.

hope this helps

regards

Marco