https://community.qlik.com/t5/QlikView/Using-variable-in-expression/m-p/1548974#M745387 <P>Like this:</P><PRE>=Avg({&lt;[Bolag], [Info Bransch] = P({$} [Info Bransch])&gt;} $(varLönsamhet))</PRE><P>Assuming the variable varLönsamhet does not include an aggregation like Sum() or Count().</P> Tue, 26 Feb 2019 05:51:51 GMT jonathandienst 2019-02-26T05:51:51Z https://community.qlik.com/t5/QlikView/Using-variable-in-expression/m-p/1548970#M745386 <P>Hi community,&nbsp;<BR /><BR />I'm trying to get the following expression to work</P><P><SPAN>=Avg({&lt;[Bolag]=,[Info Bransch]=P({$} [Info Bransch])&gt;}[$(=varLönsamhet)])</SPAN></P><P>where I want to calculate the average selected KPI from a list box for companies in the same sector as the selected one (Bolag = Company, Info Bransch = Sector). The KPI selected is captured in the varLönsamhet variable but how do I properly include the variable in the expression? Right now I get an error message.&nbsp;<BR /><BR />Thank you!&nbsp;<BR /><BR />Cheers,<BR />Philip&nbsp;</P> Sat, 16 Nov 2024 04:20:46 GMT https://community.qlik.com/t5/QlikView/Using-variable-in-expression/m-p/1548970#M745386 Hoowling 2024-11-16T04:20:46Z https://community.qlik.com/t5/QlikView/Using-variable-in-expression/m-p/1548974#M745387 <P>Like this:</P><PRE>=Avg({&lt;[Bolag], [Info Bransch] = P({$} [Info Bransch])&gt;} $(varLönsamhet))</PRE><P>Assuming the variable varLönsamhet does not include an aggregation like Sum() or Count().</P> Tue, 26 Feb 2019 05:51:51 GMT https://community.qlik.com/t5/QlikView/Using-variable-in-expression/m-p/1548974#M745387 jonathandienst 2019-02-26T05:51:51Z