Decide dynamically the aggregate function to use

[Sakura]

I have many fields for which I have to decide dynamically if I want to sum it or average it.

like if(aggregation='Sum', sum(field), average(field))

where sum(field) is for 20 fields and same is for average..

is there any way I can say, $(aggragation(field)) and aggregation is sum or average based on condition?

--aggragation= either sum or average--

[sunny_talwar · Accepted solution]

You should be able to use this

Variables with Parameters

Qlikview Parameterised Variables