topic Regarding Set Analysis Expression in QlikView https://community.qlik.com/t5/QlikView/Regarding-Set-Analysis-Expression/m-p/235775#M87023 <HTML><HEAD></HEAD><BODY><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none">Hai,</P><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"></P><P style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;"><B>I want to get all the previous year sales. I have written the expression as follows.</B></P><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"></P><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"></P><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"></P><P style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;"><B>sum</B>({ $&lt;<B>YEAR</B> = {<B>"&lt;$(=max(YEAR))"</B>},<B>MONTH</B>= {<B>"&lt;=12"</B>} &gt;} <B>SALES</B> )</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">But it is not working. Please advise me.</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">Thanks in advance..</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;"></P></BODY></HTML> Mon, 09 Nov 2009 17:04:49 GMT 2009-11-09T17:04:49Z Regarding Set Analysis Expression https://community.qlik.com/t5/QlikView/Regarding-Set-Analysis-Expression/m-p/235775#M87023 <HTML><HEAD></HEAD><BODY><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none">Hai,</P><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"></P><P style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;"><B>I want to get all the previous year sales. I have written the expression as follows.</B></P><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"></P><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"></P><P style="font-weight: bold; line-height: normal; margin: 0in 0in 0pt; mso-layout-grid-align: none"></P><P style="margin: 0in 0in 0pt; line-height: normal; mso-layout-grid-align: none;"><B>sum</B>({ $&lt;<B>YEAR</B> = {<B>"&lt;$(=max(YEAR))"</B>},<B>MONTH</B>= {<B>"&lt;=12"</B>} &gt;} <B>SALES</B> )</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">But it is not working. Please advise me.</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;">Thanks in advance..</P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;"></P><P style="margin: 0in 0in 10pt;"></P></BODY></HTML> Mon, 09 Nov 2009 17:04:49 GMT https://community.qlik.com/t5/QlikView/Regarding-Set-Analysis-Expression/m-p/235775#M87023 2009-11-09T17:04:49Z