topic Set analysis: Previous month? in App Development https://community.qlik.com/t5/App-Development/Set-analysis-Previous-month/m-p/119312#M8289 <HTML><HEAD></HEAD><BODY><P data-pm-slice="1 1 []"><SPAN style="font-size: 10pt;">Hi all! </SPAN></P><P data-pm-slice="1 1 []"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P data-pm-slice="1 1 []"><SPAN style="font-size: 10pt;">I am struggling a bit with one thing. I want to find a way to write a set analysis to sum up every month's <STRONG>previous</STRONG> month's sales. My sales data is on a monthly basis and I have managed to set up a flag to capture (IS_Previous_Month) in order to get a snap shot of what was previous month's sales for just this time period right now, so to speak. However, I would like to be able to select in a bar chart for example February 2018 and see Sales of January 2018. </SPAN></P><P></P><P>The reason for this is that I am about to develop another KPI later that involves every selected time period's previous month's sales. </P><P></P><P>How would you recommend to solve this issue? </P></BODY></HTML> Thu, 08 Nov 2018 09:35:33 GMT rasmusilestedt 2018-11-08T09:35:33Z Set analysis: Previous month? https://community.qlik.com/t5/App-Development/Set-analysis-Previous-month/m-p/119312#M8289 <HTML><HEAD></HEAD><BODY><P data-pm-slice="1 1 []"><SPAN style="font-size: 10pt;">Hi all! </SPAN></P><P data-pm-slice="1 1 []"><SPAN style="font-size: 10pt;"><BR /></SPAN></P><P data-pm-slice="1 1 []"><SPAN style="font-size: 10pt;">I am struggling a bit with one thing. I want to find a way to write a set analysis to sum up every month's <STRONG>previous</STRONG> month's sales. My sales data is on a monthly basis and I have managed to set up a flag to capture (IS_Previous_Month) in order to get a snap shot of what was previous month's sales for just this time period right now, so to speak. However, I would like to be able to select in a bar chart for example February 2018 and see Sales of January 2018. </SPAN></P><P></P><P>The reason for this is that I am about to develop another KPI later that involves every selected time period's previous month's sales. </P><P></P><P>How would you recommend to solve this issue? </P></BODY></HTML> Thu, 08 Nov 2018 09:35:33 GMT https://community.qlik.com/t5/App-Development/Set-analysis-Previous-month/m-p/119312#M8289 rasmusilestedt 2018-11-08T09:35:33Z Re: Set analysis: Previous month? https://community.qlik.com/t5/App-Development/Set-analysis-Previous-month/m-p/1509882#M36385 In set analysis you can use<BR />Num_Month = {$(=Max(Num_Month)-1)} ,Month<BR />Num_Month is numeric months 1,2,3...12<BR />This would always give you previous month from whatever is selected Tue, 20 Nov 2018 15:42:11 GMT https://community.qlik.com/t5/App-Development/Set-analysis-Previous-month/m-p/1509882#M36385 MK9885 2018-11-20T15:42:11Z