topic Syntax help please... in QlikView https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377694#M140806 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to add two different set analysis strings to the results of an IF statement, this is what I need to do:</P><P></P><P>I need to sum everything when ExtractDate equals my vJanEnd...can someone help me with the set analysis syntax please?</P></BODY></HTML> Tue, 14 Aug 2012 10:51:33 GMT samvile18 2012-08-14T10:51:33Z Syntax help please... https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377694#M140806 <HTML><HEAD></HEAD><BODY><P>Hi all,</P><P></P><P>I'm trying to add two different set analysis strings to the results of an IF statement, this is what I need to do:</P><P></P><P>I need to sum everything when ExtractDate equals my vJanEnd...can someone help me with the set analysis syntax please?</P></BODY></HTML> Tue, 14 Aug 2012 10:51:33 GMT https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377694#M140806 samvile18 2012-08-14T10:51:33Z Re: Syntax help please... https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377695#M140807 <HTML><HEAD></HEAD><BODY><P>Assuming that vJanEnd is a variable :</P><P></P><P>sum({$&lt;ExtractDate]={"$(vJanEnd)"}&gt;} [YourField])</P></BODY></HTML> Tue, 14 Aug 2012 10:55:38 GMT https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377695#M140807 giakoum 2012-08-14T10:55:38Z Re: Syntax help please... https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377696#M140808 <HTML><HEAD></HEAD><BODY><P>You're a HERO</P></BODY></HTML> Tue, 14 Aug 2012 11:03:18 GMT https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377696#M140808 samvile18 2012-08-14T11:03:18Z Re: Syntax help please... https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377697#M140809 <HTML><HEAD></HEAD><BODY><P><IMG src="https://community.qlik.com/legacyfs/online/emoticons/happy.png" /></P><P>I seriously doubt that...</P></BODY></HTML> Tue, 14 Aug 2012 11:06:04 GMT https://community.qlik.com/t5/QlikView/Syntax-help-please/m-p/377697#M140809 giakoum 2012-08-14T11:06:04Z