topic Re: Decide dynamically the aggregate function to use in QlikView https://community.qlik.com/t5/QlikView/Decide-dynamically-the-aggregate-function-to-use/m-p/1433489#M430885 <HTML><HEAD></HEAD><BODY><P>You should be able to use this</P><P><A href="https://community.qlik.com/docs/DOC-9045">Variables with Parameters</A></P><P><A href="https://community.qlik.com/docs/DOC-17393">Qlikview Parameterised Variables</A></P></BODY></HTML> Tue, 21 Nov 2017 15:28:27 GMT sunny_talwar 2017-11-21T15:28:27Z Decide dynamically the aggregate function to use https://community.qlik.com/t5/QlikView/Decide-dynamically-the-aggregate-function-to-use/m-p/1433488#M430884 <HTML><HEAD></HEAD><BODY><P>I have many fields for which I have to decide dynamically if I want to sum it or average it. </P><P></P><P>like if(aggregation='Sum', sum(field), average(field))</P><P></P><P>where sum(field) is for 20 fields and same is for average..</P><P></P><P>is there any way I can say, $(aggragation(field)) and aggregation is sum or average based on condition? </P><P></P><P><SPAN style="font-size: 13.3333px;">--aggragation= either sum or average--</SPAN></P></BODY></HTML> Tue, 21 Nov 2017 15:26:16 GMT https://community.qlik.com/t5/QlikView/Decide-dynamically-the-aggregate-function-to-use/m-p/1433488#M430884 Sakura 2017-11-21T15:26:16Z Re: Decide dynamically the aggregate function to use https://community.qlik.com/t5/QlikView/Decide-dynamically-the-aggregate-function-to-use/m-p/1433489#M430885 <HTML><HEAD></HEAD><BODY><P>You should be able to use this</P><P><A href="https://community.qlik.com/docs/DOC-9045">Variables with Parameters</A></P><P><A href="https://community.qlik.com/docs/DOC-17393">Qlikview Parameterised Variables</A></P></BODY></HTML> Tue, 21 Nov 2017 15:28:27 GMT https://community.qlik.com/t5/QlikView/Decide-dynamically-the-aggregate-function-to-use/m-p/1433489#M430885 sunny_talwar 2017-11-21T15:28:27Z