topic Using Set Expression for Current month and last month data in App Development https://community.qlik.com/t5/App-Development/Using-Set-Expression-for-Current-month-and-last-month-data/m-p/1184286#M22014 <HTML><HEAD></HEAD><BODY><P>I am trying to use a set expression to calculate a yield percentage for a KPI for current month and prior month values. </P><P></P><P>The expression I am trying to use for this is as follows</P><P></P><P>Sum({1&lt;Line={Line1, Line2, Line3},Process Month={Month(Today())}&gt;} Yield output)</P><P></P><P>I want the KPI to be fixed for a set number of lines for this month.</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 27 Sep 2016 17:07:24 GMT Anonymous 2016-09-27T17:07:24Z Using Set Expression for Current month and last month data https://community.qlik.com/t5/App-Development/Using-Set-Expression-for-Current-month-and-last-month-data/m-p/1184286#M22014 <HTML><HEAD></HEAD><BODY><P>I am trying to use a set expression to calculate a yield percentage for a KPI for current month and prior month values. </P><P></P><P>The expression I am trying to use for this is as follows</P><P></P><P>Sum({1&lt;Line={Line1, Line2, Line3},Process Month={Month(Today())}&gt;} Yield output)</P><P></P><P>I want the KPI to be fixed for a set number of lines for this month.</P><P></P><P>Thank you!</P></BODY></HTML> Tue, 27 Sep 2016 17:07:24 GMT https://community.qlik.com/t5/App-Development/Using-Set-Expression-for-Current-month-and-last-month-data/m-p/1184286#M22014 Anonymous 2016-09-27T17:07:24Z