topic Re: Set Analysis not working in QlikView https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722570#M1062974 <HTML><HEAD></HEAD><BODY><P>Great! Thanks for your help!</P></BODY></HTML> Wed, 17 Sep 2014 17:28:46 GMT 2014-09-17T17:28:46Z Set Analysis not working https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722566#M1062970 <HTML><HEAD></HEAD><BODY><P>=sum(({&lt;MasterDate_Year={$(=max(MasterDate_Year))}, </P><P>CustomerNo = p({&lt;MasterDate_Year={$(=max(MasterDate_Year)-1)} CustomerNo&gt;}) Sage.ExtensionAmt)</P><P></P><P>Three fields at play here...</P><P></P><P>MasterDate_Year = year field</P><P>CustomerNo = CustomerNo</P><P>Sage.ExtensionAmt = field to be aggregated</P><P></P><P></P><P>Qlikview is saying the expression is OK, but i'm getting "Error: Error in expressions: ')' expected.</P><P></P><P>Any ideas?</P><P></P><P>Trying to get sales for customers that had a purchase Last year.</P><P></P><P>-David</P></BODY></HTML> Wed, 17 Sep 2014 15:26:33 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722566#M1062970 2014-09-17T15:26:33Z Re: Set Analysis not working https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722567#M1062971 <HTML><HEAD></HEAD><BODY><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">Try This </P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">SUM({&lt;</P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp; MasterDate_Year = {'$(=Max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">MasterDate_Year</SPAN>))'},</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;"><SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">&nbsp;&nbsp;&nbsp;&nbsp; CustomerNo = P({1&lt;<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">MasterDate_Year = {'$(=Max(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">MasterDate_Year</SPAN>)-1)'}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">CustomerNo</SPAN></SPAN>&gt;})</SPAN></P><P style="font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif; color: #3d3d3d;">&nbsp;&nbsp;&nbsp;&nbsp; &gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Sage.ExtensionAmt)</SPAN></P></BODY></HTML> Wed, 17 Sep 2014 15:35:22 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722567#M1062971 MK_QSL 2014-09-17T15:35:22Z Re: Set Analysis not working https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722568#M1062972 <HTML><HEAD></HEAD><BODY><P>Weird...it's giving me the squiggly line under the last field, and not returning results...</P></BODY></HTML> Wed, 17 Sep 2014 15:52:20 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722568#M1062972 2014-09-17T15:52:20Z Re: Set Analysis not working https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722569#M1062973 <HTML><HEAD></HEAD><BODY><P>This should work</P><P></P><P>=SUM({&lt;MasterDate_Year = {'$(=Max(MasterDate_Year))'}, CustomerNo = P({1&lt;MasterDate_Year = {'$(=Max(MasterDate_Year)-1)'}&gt;})&gt;}Sage.ExtensionAmt)</P></BODY></HTML> Wed, 17 Sep 2014 15:57:36 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722569#M1062973 MK_QSL 2014-09-17T15:57:36Z Re: Set Analysis not working https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722570#M1062974 <HTML><HEAD></HEAD><BODY><P>Great! Thanks for your help!</P></BODY></HTML> Wed, 17 Sep 2014 17:28:46 GMT https://community.qlik.com/t5/QlikView/Set-Analysis-not-working/m-p/722570#M1062974 2014-09-17T17:28:46Z