topic Re: Generating the data for previous quarter and month in QlikView https://community.qlik.com/t5/QlikView/Generating-the-data-for-previous-quarter-and-month/m-p/1444319#M459207 <HTML><HEAD></HEAD><BODY><P>I am facing the same problem .. kindly help</P></BODY></HTML> Fri, 27 Oct 2017 10:03:42 GMT nehapathak 2017-10-27T10:03:42Z Generating the data for previous quarter and month https://community.qlik.com/t5/QlikView/Generating-the-data-for-previous-quarter-and-month/m-p/1444318#M459206 <HTML><HEAD></HEAD><BODY><P>I have 2 filters one for quarter and other for month. I have derived quarter from month (1-3[Q1],4-6[Q2],7-9[Q3],10-12(Q4)).&nbsp; I want to generate data for previous quarter and month simultaneously as values are selected in the filters. But the problem I am facing is I am&nbsp; able to generate for either one of them. <STRONG style="text-decoration: underline;">Here accounting period is the 'month'</STRONG>.</P><P></P><P>Whenever I select a quarter for ex Q2 it shows me data for Q1 but when I alter the month it shows 0 value in the measure. </P><P></P><P>I want the system to show that If I select month as 4 and 6 the previous measure should show me data quarter 1, month- 1 and 3 correspondingly.</P><P></P><P><IMG alt="Capture.JPG" class="jive-image image-1" src="https://community.qlik.com/legacyfs/online/181215_Capture.JPG" style="width: 620px; height: 317px;" /></P><P></P><P></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">I am using the following measure for generating previous month measure </SPAN></P><P><SPAN style="color: #000000; font-family: Calibri; font-size: 12pt;">Num(sum({$&lt;Quaters={"$(=GetFieldSelections(Quaters)-1)"}&gt;}[Service Revenue]),'##.0'),</SPAN></P></BODY></HTML> Fri, 27 Oct 2017 04:34:04 GMT https://community.qlik.com/t5/QlikView/Generating-the-data-for-previous-quarter-and-month/m-p/1444318#M459206 siddharthsoam 2017-10-27T04:34:04Z Re: Generating the data for previous quarter and month https://community.qlik.com/t5/QlikView/Generating-the-data-for-previous-quarter-and-month/m-p/1444319#M459207 <HTML><HEAD></HEAD><BODY><P>I am facing the same problem .. kindly help</P></BODY></HTML> Fri, 27 Oct 2017 10:03:42 GMT https://community.qlik.com/t5/QlikView/Generating-the-data-for-previous-quarter-and-month/m-p/1444319#M459207 nehapathak 2017-10-27T10:03:42Z