topic Re: Expression help.. in QlikView https://community.qlik.com/t5/QlikView/Expression-help/m-p/717882#M258011 <HTML><HEAD></HEAD><BODY><P>COUNT(Distinct {&lt;Month = {'$(=Max(Month))'}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">material) + COUNT(Distinct {&lt;Month = {'$(=Date(Max(Month)-1,'MMM'))'}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">material)</SPAN></SPAN></P></BODY></HTML> Mon, 21 Jul 2014 12:50:20 GMT MK_QSL 2014-07-21T12:50:20Z Expression help.. https://community.qlik.com/t5/QlikView/Expression-help/m-p/717881#M258010 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P></P><P>I have to write an expression for -on selection of a particular month i want count of material whose production qty is 0 for the selected month as well as for its previous month.</P><P></P><P>kindly help.</P><P>Regards</P></BODY></HTML> Mon, 21 Jul 2014 12:47:17 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/717881#M258010 2014-07-21T12:47:17Z Re: Expression help.. https://community.qlik.com/t5/QlikView/Expression-help/m-p/717882#M258011 <HTML><HEAD></HEAD><BODY><P>COUNT(Distinct {&lt;Month = {'$(=Max(Month))'}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">material) + COUNT(Distinct {&lt;Month = {'$(=Date(Max(Month)-1,'MMM'))'}&gt;}<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">material)</SPAN></SPAN></P></BODY></HTML> Mon, 21 Jul 2014 12:50:20 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/717882#M258011 MK_QSL 2014-07-21T12:50:20Z Re: Expression help.. https://community.qlik.com/t5/QlikView/Expression-help/m-p/717883#M258012 <HTML><HEAD></HEAD><BODY><P>I also need to insert Production qty condition in expression</P></BODY></HTML> Mon, 21 Jul 2014 13:10:27 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/717883#M258012 2014-07-21T13:10:27Z