topic Set Analysis Syntax in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/285206#M106064 <HTML><HEAD></HEAD><BODY><P>Morning all,</P><P></P><P>Can someone help me with the following syntax please;</P><P></P><P>=<SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">[Date Received]</SPAN>={'$(=Date([Upload Date]))'}, <SPAN style="color: #800000;">[Sales Channel]</SPAN>={'FriendsLife'},<SPAN style="color: #800000;">[Conversion Status]</SPAN>={'2 Tender Doc Issued'}, <SPAN style="color: #800000;">Status</SPAN>={'Won','Live'}&gt;}<SPAN style="color: #800000;">APE</SPAN>) </P><P></P><P>This works fine at the moment as the two date fields are normal date fields so DD/MM/YYYY, I need to change the two date fields to fields to MonthName fields so they now look like this MMM-YYYY e.g. Jan-2012</P><P></P><P>As soon as I change the field names in the above syntax the results stop working and I keep getting zero's...I can;t figure out for the life of me what the problem is.</P><P></P><P>The new fields are called <SPAN style="color: #800000;">Date Received Month/Year</SPAN> and <SPAN style="color: #800000;">Upload Month/Year</SPAN></P><P></P><P>Can anyone help?</P></BODY></HTML> Wed, 18 Jan 2012 10:25:59 GMT samvile18 2012-01-18T10:25:59Z Set Analysis Syntax https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/285206#M106064 <HTML><HEAD></HEAD><BODY><P>Morning all,</P><P></P><P>Can someone help me with the following syntax please;</P><P></P><P>=<SPAN style="color: #0000ff;">sum</SPAN>({&lt;<SPAN style="color: #800000;">[Date Received]</SPAN>={'$(=Date([Upload Date]))'}, <SPAN style="color: #800000;">[Sales Channel]</SPAN>={'FriendsLife'},<SPAN style="color: #800000;">[Conversion Status]</SPAN>={'2 Tender Doc Issued'}, <SPAN style="color: #800000;">Status</SPAN>={'Won','Live'}&gt;}<SPAN style="color: #800000;">APE</SPAN>) </P><P></P><P>This works fine at the moment as the two date fields are normal date fields so DD/MM/YYYY, I need to change the two date fields to fields to MonthName fields so they now look like this MMM-YYYY e.g. Jan-2012</P><P></P><P>As soon as I change the field names in the above syntax the results stop working and I keep getting zero's...I can;t figure out for the life of me what the problem is.</P><P></P><P>The new fields are called <SPAN style="color: #800000;">Date Received Month/Year</SPAN> and <SPAN style="color: #800000;">Upload Month/Year</SPAN></P><P></P><P>Can anyone help?</P></BODY></HTML> Wed, 18 Jan 2012 10:25:59 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/285206#M106064 samvile18 2012-01-18T10:25:59Z Set Analysis Syntax https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/285207#M106065 <HTML><HEAD></HEAD><BODY><P> This has been answered in a separate post</P></BODY></HTML> Fri, 20 Jan 2012 10:43:13 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-Syntax/m-p/285207#M106065 samvile18 2012-01-20T10:43:13Z