topic Re: please help in attach file . in QlikView https://community.qlik.com/t5/QlikView/please-help-in-attach-file/m-p/136979#M762591 <HTML><HEAD></HEAD><BODY><P>1) Change the expression to this</P><P><STRONG>=sum({&lt;Date={2019}&gt;} [sale])/sum(<SPAN style="color: #ff0000;">{1}</SPAN> sale)</STRONG></P><P></P><P>2) Change the expression to this</P><P><STRONG>Sum({&lt;[Date]={"$(v1)"}&gt;} [sale])/sum(TOTAL [sale])</STRONG></P></BODY></HTML> Mon, 30 Jul 2018 18:07:42 GMT sunny_talwar 2018-07-30T18:07:42Z please help in attach file . https://community.qlik.com/t5/QlikView/please-help-in-attach-file/m-p/136978#M762590 <HTML><HEAD></HEAD><BODY><P>I make a simple file with 2 problem in it :</P><P> 1: change list box value , change text box with absolute formula&nbsp; (TOTAL function)</P><P>2:change input box donot change gage formula</P><P></P><P>please help</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/please-help-in-attach-file/m-p/136978#M762590 Anonymous 2020-11-25T16:16:04Z Re: please help in attach file . https://community.qlik.com/t5/QlikView/please-help-in-attach-file/m-p/136979#M762591 <HTML><HEAD></HEAD><BODY><P>1) Change the expression to this</P><P><STRONG>=sum({&lt;Date={2019}&gt;} [sale])/sum(<SPAN style="color: #ff0000;">{1}</SPAN> sale)</STRONG></P><P></P><P>2) Change the expression to this</P><P><STRONG>Sum({&lt;[Date]={"$(v1)"}&gt;} [sale])/sum(TOTAL [sale])</STRONG></P></BODY></HTML> Mon, 30 Jul 2018 18:07:42 GMT https://community.qlik.com/t5/QlikView/please-help-in-attach-file/m-p/136979#M762591 sunny_talwar 2018-07-30T18:07:42Z