https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546756#M746150 <P>Remove the single quotes around 2018 and 11 and try. It should work if you have those field properly defined</P> Wed, 20 Feb 2019 09:11:32 GMT pradosh_thakur 2019-02-20T09:11:32Z https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546629#M746147 <P>&nbsp;</P><P>&nbsp;</P> Wed, 25 Nov 2020 16:16:04 GMT https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546629#M746147 rr231 2020-11-25T16:16:04Z https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546636#M746148 <P>I recommend that you post the data from which you are taking your expression.&nbsp; If possible put a small example in excel or something like that and explain your case</P> Wed, 20 Feb 2019 00:10:03 GMT https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546636#M746148 jolivares 2019-02-20T00:10:03Z https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546701#M746149 <P>I doubt you have a YEAR field, Please check the field in your data, and qlik is case sensitive. Hope you got my point!</P> Wed, 20 Feb 2019 07:20:12 GMT https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546701#M746149 shiveshsingh 2019-02-20T07:20:12Z https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546756#M746150 <P>Remove the single quotes around 2018 and 11 and try. It should work if you have those field properly defined</P> Wed, 20 Feb 2019 09:11:32 GMT https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546756#M746150 pradosh_thakur 2019-02-20T09:11:32Z https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546757#M746151 <P>It's not advisable to hard card the data ,so if possible dot hard code.</P> Wed, 20 Feb 2019 09:12:33 GMT https://community.qlik.com/t5/QlikView/Variance-between-last-two-months/m-p/1546757#M746151 pradosh_thakur 2019-02-20T09:12:33Z