topic Re: What is wrong with this set analysis expression in QlikView https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-set-analysis-expression/m-p/1241951#M394336 <HTML><HEAD></HEAD><BODY><P>Could you be a bit more specific what 'is not working' exactely means? No results, wrong results, etc?</P><P></P><P>First check that your dollar sign expansions return the expected values, correctly formatted matching the field value format of Date_k.</P><P></P><P>Second, if you make active selections in other fields, these may interefere with the set you define in your set analysis.</P><P>You may need to clear fields the user may select in (e.g. Month field).</P><P></P><P>It's explained in more details in</P><P><A href="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting" title="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting">The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync</A>‌</P><P><A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Sat, 10 Dec 2016 22:51:24 GMT swuehl 2016-12-10T22:51:24Z What is wrong with this set analysis expression https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-set-analysis-expression/m-p/1241950#M394335 <HTML><HEAD></HEAD><BODY><P>Why is it not working. Is there some syntax mistake</P><P></P><P>sum({$&lt;Date_k={"&gt;=$(=date(max(Date_k)-300,'yyyyMMdd'))&lt;=$(=date(max(Date_k),'yyyyMMdd'))"}&gt;}QtyOnHand)</P><P></P><P></P><P>Shah</P></BODY></HTML> Sat, 10 Dec 2016 22:41:53 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-set-analysis-expression/m-p/1241950#M394335 2016-12-10T22:41:53Z Re: What is wrong with this set analysis expression https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-set-analysis-expression/m-p/1241951#M394336 <HTML><HEAD></HEAD><BODY><P>Could you be a bit more specific what 'is not working' exactely means? No results, wrong results, etc?</P><P></P><P>First check that your dollar sign expansions return the expected values, correctly formatted matching the field value format of Date_k.</P><P></P><P>Second, if you make active selections in other fields, these may interefere with the set you define in your set analysis.</P><P>You may need to clear fields the user may select in (e.g. Month field).</P><P></P><P>It's explained in more details in</P><P><A href="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting" title="http://aftersync.com/blog/the-magic-of-set-analysis-point-in-time-reporting">The Magic of Set Analysis - Point In Time Reporting • Blog • AfterSync</A>‌</P><P><A href="https://community.qlik.com/qlik-blogpost/4394">Dates in Set Analysis</A></P></BODY></HTML> Sat, 10 Dec 2016 22:51:24 GMT https://community.qlik.com/t5/QlikView/What-is-wrong-with-this-set-analysis-expression/m-p/1241951#M394336 swuehl 2016-12-10T22:51:24Z