topic Showing previous quarter value in QlikView https://community.qlik.com/t5/QlikView/Showing-previous-quarter-value/m-p/388312#M571378 <HTML><HEAD></HEAD><BODY><P>I'm creating a balance sheet report and once the year and quarter input box is set, i need to show balanace until the specified quarter for previous year, balance for the specified year until previous quarter and also balance from current year until the specifiesd quarter.</P><P></P><P>Since the quarter that user specifies is in string value i'm having a difficult time in minusing the quearters. </P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>First Expression : sum(if(PostingYear=ReportingYear-1 and PostingQuarter&lt;=ReportingQuarter, Amount))/1000&nbsp; <STRONG>(The values for this are correct)</STRONG></P><P></P><P><STRONG>(The values for the below are not showing correctrly)</STRONG></P><P>Second Expression: sum(if(PostingYear&lt;=ReportingYear and PostingQuarter&lt;ReportingQuarter, Amount))/1000</P><P></P><P>Third Expression: sum(if(PostingYear&lt;=ReportingYear and PostingQuarter&lt;=ReportingQuarter, Amount))/1000</P><P></P><P></P><P>Can anyone help me on this or any other suggestions to do this better are welcomed.</P></BODY></HTML> Sun, 09 Sep 2012 05:05:01 GMT 2012-09-09T05:05:01Z Showing previous quarter value https://community.qlik.com/t5/QlikView/Showing-previous-quarter-value/m-p/388312#M571378 <HTML><HEAD></HEAD><BODY><P>I'm creating a balance sheet report and once the year and quarter input box is set, i need to show balanace until the specified quarter for previous year, balance for the specified year until previous quarter and also balance from current year until the specifiesd quarter.</P><P></P><P>Since the quarter that user specifies is in string value i'm having a difficult time in minusing the quearters. </P><P></P><P><IMG class="jiveImage" src="https://community.qlik.com/" style="max-width: 1200px; max-height: 900px;" /></P><P></P><P>First Expression : sum(if(PostingYear=ReportingYear-1 and PostingQuarter&lt;=ReportingQuarter, Amount))/1000&nbsp; <STRONG>(The values for this are correct)</STRONG></P><P></P><P><STRONG>(The values for the below are not showing correctrly)</STRONG></P><P>Second Expression: sum(if(PostingYear&lt;=ReportingYear and PostingQuarter&lt;ReportingQuarter, Amount))/1000</P><P></P><P>Third Expression: sum(if(PostingYear&lt;=ReportingYear and PostingQuarter&lt;=ReportingQuarter, Amount))/1000</P><P></P><P></P><P>Can anyone help me on this or any other suggestions to do this better are welcomed.</P></BODY></HTML> Sun, 09 Sep 2012 05:05:01 GMT https://community.qlik.com/t5/QlikView/Showing-previous-quarter-value/m-p/388312#M571378 2012-09-09T05:05:01Z