topic change set analysis in Management & Governance https://community.qlik.com/t5/Management-Governance/change-set-analysis/m-p/1318943#M9554 <HTML><HEAD></HEAD><BODY><P>Hello I have this set analysis expression :</P><P></P><P>Count({&lt;[Calendar date]=, [%Year week SEQ]={$(=max([%Year week SEQ])-1)} &gt;}Value)</P><P></P><P>This expression display the value of the max week of the month ,</P><P>I would like to display the total value of selected months not just the last week </P><P></P><P>Regards</P></BODY></HTML> Wed, 10 May 2017 12:56:11 GMT zied_ahmed1 2017-05-10T12:56:11Z change set analysis https://community.qlik.com/t5/Management-Governance/change-set-analysis/m-p/1318943#M9554 <HTML><HEAD></HEAD><BODY><P>Hello I have this set analysis expression :</P><P></P><P>Count({&lt;[Calendar date]=, [%Year week SEQ]={$(=max([%Year week SEQ])-1)} &gt;}Value)</P><P></P><P>This expression display the value of the max week of the month ,</P><P>I would like to display the total value of selected months not just the last week </P><P></P><P>Regards</P></BODY></HTML> Wed, 10 May 2017 12:56:11 GMT https://community.qlik.com/t5/Management-Governance/change-set-analysis/m-p/1318943#M9554 zied_ahmed1 2017-05-10T12:56:11Z Re: change set analysis https://community.qlik.com/t5/Management-Governance/change-set-analysis/m-p/1318944#M9555 <HTML><HEAD></HEAD><BODY><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">then remove the Week part</SPAN></P><P><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; font-size: 13px;">Count({&lt;[Calendar date]=&gt;}Value)</SPAN></P></BODY></HTML> Wed, 10 May 2017 13:25:54 GMT https://community.qlik.com/t5/Management-Governance/change-set-analysis/m-p/1318944#M9555 vinieme12 2017-05-10T13:25:54Z