https://community.qlik.com/t5/App-Development/Difference-between-Financial-Year-Quarters/m-p/2543571#M109565 <P>Hi,</P><P>&nbsp; &nbsp;How Do I calculate the difference between two financial quarters?</P><P>Column E - Column C = (in number)</P><P>example for First row the difference should be 1</P><DIV class="">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Neha121_0-1771217201815.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/186908i30740DD23B635F37/image-size/medium?v=v2&amp;px=400" role="button" title="Neha121_0-1771217201815.png" alt="Neha121_0-1771217201815.png" /></span></P><P>&nbsp;</P> Mon, 23 Feb 2026 23:07:01 GMT Neha121 2026-02-23T23:07:01Z https://community.qlik.com/t5/App-Development/Difference-between-Financial-Year-Quarters/m-p/2543571#M109565 <P>Hi,</P><P>&nbsp; &nbsp;How Do I calculate the difference between two financial quarters?</P><P>Column E - Column C = (in number)</P><P>example for First row the difference should be 1</P><DIV class="">&nbsp;</DIV><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Neha121_0-1771217201815.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/186908i30740DD23B635F37/image-size/medium?v=v2&amp;px=400" role="button" title="Neha121_0-1771217201815.png" alt="Neha121_0-1771217201815.png" /></span></P><P>&nbsp;</P> Mon, 23 Feb 2026 23:07:01 GMT https://community.qlik.com/t5/App-Development/Difference-between-Financial-Year-Quarters/m-p/2543571#M109565 Neha121 2026-02-23T23:07:01Z https://community.qlik.com/t5/App-Development/Difference-between-Financial-Year-Quarters/m-p/2543587#M109568 <P>(<BR />(Left(FQTR_Transaction, 4) * 4) + Right(FQTR_Transaction, 1)<BR />)<BR />-<BR />(<BR />(Left(FQTR_OCCURRED, 4) * 4) + Right(FQTR_OCCURRED, 1)<BR />)</P> Tue, 24 Feb 2026 06:33:37 GMT https://community.qlik.com/t5/App-Development/Difference-between-Financial-Year-Quarters/m-p/2543587#M109568 robert_mika 2026-02-24T06:33:37Z https://community.qlik.com/t5/App-Development/Difference-between-Financial-Year-Quarters/m-p/2543588#M109569 <P>Try this!</P><P>=Replace(<SPAN>FQTR_Transaction</SPAN>, 'Q','') - Replace(<SPAN>FQTR_OCCURRED</SPAN>, 'Q','')</P> Tue, 24 Feb 2026 06:44:14 GMT https://community.qlik.com/t5/App-Development/Difference-between-Financial-Year-Quarters/m-p/2543588#M109569 Nagaraju_KCS 2026-02-24T06:44:14Z