topic Dynamic financial year in set analysis in App Development https://community.qlik.com/t5/App-Development/Dynamic-financial-year-in-set-analysis/m-p/33073#M2210 <HTML><HEAD></HEAD><BODY><P class="6MLBodyTxt"><SPAN lang="EN-GB">Hi All,</SPAN></P><P class="6MLBodyTxt"></P><P class="6MLBodyTxt"><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif; color: #545454; background: white;"> </SPAN><SPAN lang="EN-GB">I have following expression here I want to take </SPAN>dynamic financial year(In Set expression) as per user selected '2016-2017' and&nbsp; '2017-2018' how to achive this.</P><P class="6MLBodyTxt"></P><P class="6MLBodyTxt"></P><P class="6MLBodyTxt"><SPAN lang="EN-GB">Thanks,</SPAN></P><P class="6MLBodyTxt"><SPAN lang="EN-GB">Krishna</SPAN></P></BODY></HTML> Thu, 01 Mar 2018 07:51:01 GMT Anonymous 2018-03-01T07:51:01Z Dynamic financial year in set analysis https://community.qlik.com/t5/App-Development/Dynamic-financial-year-in-set-analysis/m-p/33073#M2210 <HTML><HEAD></HEAD><BODY><P class="6MLBodyTxt"><SPAN lang="EN-GB">Hi All,</SPAN></P><P class="6MLBodyTxt"></P><P class="6MLBodyTxt"><SPAN lang="EN-GB" style="font-family: 'Arial',sans-serif; color: #545454; background: white;"> </SPAN><SPAN lang="EN-GB">I have following expression here I want to take </SPAN>dynamic financial year(In Set expression) as per user selected '2016-2017' and&nbsp; '2017-2018' how to achive this.</P><P class="6MLBodyTxt"></P><P class="6MLBodyTxt"></P><P class="6MLBodyTxt"><SPAN lang="EN-GB">Thanks,</SPAN></P><P class="6MLBodyTxt"><SPAN lang="EN-GB">Krishna</SPAN></P></BODY></HTML> Thu, 01 Mar 2018 07:51:01 GMT https://community.qlik.com/t5/App-Development/Dynamic-financial-year-in-set-analysis/m-p/33073#M2210 Anonymous 2018-03-01T07:51:01Z Re: Dynamic financial year in set analysis https://community.qlik.com/t5/App-Development/Dynamic-financial-year-in-set-analysis/m-p/33074#M2211 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P></P><P>Try this : sum({&lt;Year={"&gt;=$(=max(<SPAN style="font-size: 13.3333px;">Year</SPAN>)-1) &lt;= $(=max(<SPAN style="font-size: 13.3333px;">Year</SPAN>))"}&gt;}Amount)</P></BODY></HTML> Thu, 01 Mar 2018 08:56:14 GMT https://community.qlik.com/t5/App-Development/Dynamic-financial-year-in-set-analysis/m-p/33074#M2211 jaumecf23 2018-03-01T08:56:14Z