topic Re: Expression help in QlikView https://community.qlik.com/t5/QlikView/Expression-help/m-p/593462#M1115215 <HTML><HEAD></HEAD><BODY><P>Are these two tables joined? </P><P>Maybe you should join them using IntervalMatch()? </P></BODY></HTML> Mon, 17 Feb 2014 13:20:39 GMT 2014-02-17T13:20:39Z Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/593460#M1115213 <HTML><HEAD></HEAD><BODY><P>hi, </P><P>I am trying to write an expression and need some help. </P><P></P><P>I have a dimension of 'Month'</P><P></P><P>and i need to count 'Offline ID' where 'Offline Date' falls within each month. </P><P></P><P>Can anyone help please?</P></BODY></HTML> Mon, 17 Feb 2014 13:16:23 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/593460#M1115213 hopkinsc 2014-02-17T13:16:23Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/593461#M1115214 <HTML><HEAD></HEAD><BODY><P>You should create the "Month" from the "Offline Date" already in the script. Then the count will easily be displayed in a chart with Month as dimension and Count(distinct [Offline ID]) as expression.</P><P></P><P>HIC</P></BODY></HTML> Mon, 17 Feb 2014 13:19:53 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/593461#M1115214 hic 2014-02-17T13:19:53Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/593462#M1115215 <HTML><HEAD></HEAD><BODY><P>Are these two tables joined? </P><P>Maybe you should join them using IntervalMatch()? </P></BODY></HTML> Mon, 17 Feb 2014 13:20:39 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/593462#M1115215 2014-02-17T13:20:39Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/593463#M1115216 <HTML><HEAD></HEAD><BODY><P>IF(not Isnull(<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">Offline Date</SPAN>),<SPAN style="color: #3d3d3d; font-family: 'Helvetica Neue', Helvetica, Arial, 'Lucida Grande', sans-serif;">count (Offline ID)</SPAN>)</P></BODY></HTML> Mon, 17 Feb 2014 13:26:56 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/593463#M1115216 2014-02-17T13:26:56Z Re: Expression help https://community.qlik.com/t5/QlikView/Expression-help/m-p/593464#M1115217 <HTML><HEAD></HEAD><BODY><P>Use Henrics suggestion. Applying the transformation in script will have performance benefits for you in the front-end. As he stated, the expression then is very simple</P></BODY></HTML> Mon, 17 Feb 2014 13:36:07 GMT https://community.qlik.com/t5/QlikView/Expression-help/m-p/593464#M1115217 2014-02-17T13:36:07Z