topic Previous Month with Master Calendar in QlikView https://community.qlik.com/t5/QlikView/Previous-Month-with-Master-Calendar/m-p/131235#M19755 <HTML><HEAD></HEAD><BODY><P>im trying to get the values for the previous fiscal month and Previous Quarter using set analysis.</P><P>My current formula is</P><P>Current Month:</P><P><STRONG>=Sum({&lt;FQuarter=,FMonth=, [Date]= ,FYear={$(vMax_Year)}, fMonth={$(vMax_Month)}&gt;}[Actuals])</STRONG></P><P>Current Quarter:</P><P><STRONG>=Sum({&lt;FQuarter=,FMonth=, [Date]= ,FYear={$(vMax_Year)}, FQuarter_Num={$(vMax_Quater)}&gt;}[Actuals])</STRONG></P><P>my fiscal year starts in September .</P><P>i don't want to do Fmonth-1, because what if i was in the 1st month of the fiscal year.</P><P>Please let me know what i am doing wrong </P></BODY></HTML> Sun, 16 Sep 2018 16:56:23 GMT triekong 2018-09-16T16:56:23Z Previous Month with Master Calendar https://community.qlik.com/t5/QlikView/Previous-Month-with-Master-Calendar/m-p/131235#M19755 <HTML><HEAD></HEAD><BODY><P>im trying to get the values for the previous fiscal month and Previous Quarter using set analysis.</P><P>My current formula is</P><P>Current Month:</P><P><STRONG>=Sum({&lt;FQuarter=,FMonth=, [Date]= ,FYear={$(vMax_Year)}, fMonth={$(vMax_Month)}&gt;}[Actuals])</STRONG></P><P>Current Quarter:</P><P><STRONG>=Sum({&lt;FQuarter=,FMonth=, [Date]= ,FYear={$(vMax_Year)}, FQuarter_Num={$(vMax_Quater)}&gt;}[Actuals])</STRONG></P><P>my fiscal year starts in September .</P><P>i don't want to do Fmonth-1, because what if i was in the 1st month of the fiscal year.</P><P>Please let me know what i am doing wrong </P></BODY></HTML> Sun, 16 Sep 2018 16:56:23 GMT https://community.qlik.com/t5/QlikView/Previous-Month-with-Master-Calendar/m-p/131235#M19755 triekong 2018-09-16T16:56:23Z