topic Re: Set Analysis with a Function Incorporated in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-Function-Incorporated/m-p/1328621#M410710 <HTML><HEAD></HEAD><BODY><P>Try to create Month in script and then use same field it will achieve.</P></BODY></HTML> Thu, 27 Apr 2017 07:06:51 GMT Anil_Babu_Samineni 2017-04-27T07:06:51Z Set Analysis with a Function Incorporated https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-Function-Incorporated/m-p/1328620#M410709 <HTML><HEAD></HEAD><BODY><P>Dear Qlikview User,</P><P></P><P>I am trying to write an expression which already includes Set analysis, and now I want to add in the Month function nut am unsure of the correct code to incorporate it. My expression is below and any help would be greatly appreciated</P><P></P><P>sum({$&lt;Week_Number,Month,QuarterName,FiscalYear,<SPAN style="color: #ff0000;">Month(FactDateNum)</SPAN>=P(FactDateNum_prevMonth2)&gt;} If(RTT_WEEKS_WAIT &lt;'18', RTT_COUNTER)))</P><P></P><P>Kind Regards</P><P>Helen</P></BODY></HTML> Thu, 27 Apr 2017 07:02:22 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-Function-Incorporated/m-p/1328620#M410709 helen_pip 2017-04-27T07:02:22Z Re: Set Analysis with a Function Incorporated https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-Function-Incorporated/m-p/1328621#M410710 <HTML><HEAD></HEAD><BODY><P>Try to create Month in script and then use same field it will achieve.</P></BODY></HTML> Thu, 27 Apr 2017 07:06:51 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-with-a-Function-Incorporated/m-p/1328621#M410710 Anil_Babu_Samineni 2017-04-27T07:06:51Z