https://community.qlik.com/t5/App-Development/set-analysis-on-expression/m-p/1603707#M44681 <P>hey,</P><P>i need this expression to not be impacted by any selections:</P><P>=NUM((sum(TOTAL_SALES) - sum(SALES)/ sum(TOTAL_SALES), '0.00%')</P><P>i tried:</P><P>=NUM((sum({1}TOTAL_SALES) - sum({1}SALES))/ sum({1}TOTAL_SALES), '0.00%')</P><P>but this doesnt work&nbsp;</P><P>any advice is much appreciated</P> Sat, 16 Nov 2024 05:14:25 GMT anonymous1 2024-11-16T05:14:25Z https://community.qlik.com/t5/App-Development/set-analysis-on-expression/m-p/1603707#M44681 <P>hey,</P><P>i need this expression to not be impacted by any selections:</P><P>=NUM((sum(TOTAL_SALES) - sum(SALES)/ sum(TOTAL_SALES), '0.00%')</P><P>i tried:</P><P>=NUM((sum({1}TOTAL_SALES) - sum({1}SALES))/ sum({1}TOTAL_SALES), '0.00%')</P><P>but this doesnt work&nbsp;</P><P>any advice is much appreciated</P> Sat, 16 Nov 2024 05:14:25 GMT https://community.qlik.com/t5/App-Development/set-analysis-on-expression/m-p/1603707#M44681 anonymous1 2024-11-16T05:14:25Z https://community.qlik.com/t5/App-Development/set-analysis-on-expression/m-p/1603741#M44683 Whats the issue you are getting?<BR />Code seems right Thu, 18 Jul 2019 14:11:15 GMT https://community.qlik.com/t5/App-Development/set-analysis-on-expression/m-p/1603741#M44683 dplr-rn 2019-07-18T14:11:15Z https://community.qlik.com/t5/App-Development/set-analysis-on-expression/m-p/1603743#M44684 <P>when I make a selection on my dashboard, this expression keeps changing</P> Thu, 18 Jul 2019 14:13:04 GMT https://community.qlik.com/t5/App-Development/set-analysis-on-expression/m-p/1603743#M44684 anonymous1 2019-07-18T14:13:04Z