topic Re: Chart with variation between days in QlikView https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198985#M883281 <HTML><HEAD></HEAD><BODY><P>worked!</P><P>thanks</P></BODY></HTML> Mon, 03 Oct 2016 18:27:30 GMT silvia_assuncao 2016-10-03T18:27:30Z Chart with variation between days https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198981#M883277 <HTML><HEAD></HEAD><BODY><P>Hi! </P><P>I have a chart with values per day and asset code. And I'd like to have the variation from one day to the other for each asset code. </P><P>how can I do it?</P></BODY></HTML> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198981#M883277 silvia_assuncao 2020-11-25T16:16:04Z Re: Chart with variation between days https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198982#M883278 <HTML><HEAD></HEAD><BODY><P>Is this the goal?</P><P></P><P><IMG alt="Capture.PNG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/139472_Capture.PNG" style="height: 202px; width: 620px;" /></P><P></P><P>Expression:</P><P><STRONG>Aggr(Sum(VALUE)-Above(Sum(VALUE)), ASSET_CODE, DAY)</STRONG></P></BODY></HTML> Mon, 03 Oct 2016 17:18:09 GMT https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198982#M883278 sunny_talwar 2016-10-03T17:18:09Z Re: Chart with variation between days https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198983#M883279 <HTML><HEAD></HEAD><BODY><P>My origninal expression has some setanalysis, how can do as you did above in this case?</P><P></P><P>(SUM({$&lt;[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}&gt;}(VALUE)/100))</P></BODY></HTML> Mon, 03 Oct 2016 17:45:32 GMT https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198983#M883279 silvia_assuncao 2016-10-03T17:45:32Z Re: Chart with variation between days https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198984#M883280 <HTML><HEAD></HEAD><BODY><P>Then try this:</P><P></P><P><STRONG style="font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Aggr(<SPAN style="color: #ff0000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum({$&lt;[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}&gt;}(VALUE)/100)</SPAN>-Above(<STRONG style="color: #ff0000; font-size: 13px; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sum({$&lt;[ANO DO PREGAO] = {'2016'},[MES PREGAO]={'09'}&gt;}(VALUE)/100)</STRONG>), ASSET_CODE, DAY)</STRONG></P></BODY></HTML> Mon, 03 Oct 2016 17:56:04 GMT https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198984#M883280 sunny_talwar 2016-10-03T17:56:04Z Re: Chart with variation between days https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198985#M883281 <HTML><HEAD></HEAD><BODY><P>worked!</P><P>thanks</P></BODY></HTML> Mon, 03 Oct 2016 18:27:30 GMT https://community.qlik.com/t5/QlikView/Chart-with-variation-between-days/m-p/1198985#M883281 silvia_assuncao 2016-10-03T18:27:30Z