topic Problem with the expression in QlikView https://community.qlik.com/t5/QlikView/Problem-with-the-expression/m-p/494253#M184878 <HTML><HEAD></HEAD><BODY><P>The view i am trying to create is you have a MTD count,</P><P></P><P>FYI-for both of these the dimesions are User and application name also i am performing this in a pivot table.</P><P></P><P>MTD utilization count- how many times so far does the user performed a session(count of days) as an example i will asume as today is 21st so out 21 days in this month 10 days the user performed a session(doesnt matter about number of sessions on same day).</P><P></P><P>Does this expression makes sense for the above condition as i being skeptical about it?</P><P>=count({$&lt;Date={"&gt;=$(=(MonthStart(Max(Date))))&lt;=$(=(Date(today(01/31/2013)-1)))"},[Session Start]={"*"}&gt;}DISTINCT Day)</P><P></P><P>MTD actual -how many days is it so far in month(lets just say until today its 20 days and it should be dynamic with the selection between different months and years) <STRONG>ALSO the # days are&nbsp; including all the days at this point it doesn't matter if its a non businessday we still consider.</STRONG></P><P>What should be my condition to show just the numbers days passed so far in this month(MTD)?</P></BODY></HTML> Thu, 20 Jun 2013 18:58:12 GMT 2013-06-20T18:58:12Z Problem with the expression https://community.qlik.com/t5/QlikView/Problem-with-the-expression/m-p/494253#M184878 <HTML><HEAD></HEAD><BODY><P>The view i am trying to create is you have a MTD count,</P><P></P><P>FYI-for both of these the dimesions are User and application name also i am performing this in a pivot table.</P><P></P><P>MTD utilization count- how many times so far does the user performed a session(count of days) as an example i will asume as today is 21st so out 21 days in this month 10 days the user performed a session(doesnt matter about number of sessions on same day).</P><P></P><P>Does this expression makes sense for the above condition as i being skeptical about it?</P><P>=count({$&lt;Date={"&gt;=$(=(MonthStart(Max(Date))))&lt;=$(=(Date(today(01/31/2013)-1)))"},[Session Start]={"*"}&gt;}DISTINCT Day)</P><P></P><P>MTD actual -how many days is it so far in month(lets just say until today its 20 days and it should be dynamic with the selection between different months and years) <STRONG>ALSO the # days are&nbsp; including all the days at this point it doesn't matter if its a non businessday we still consider.</STRONG></P><P>What should be my condition to show just the numbers days passed so far in this month(MTD)?</P></BODY></HTML> Thu, 20 Jun 2013 18:58:12 GMT https://community.qlik.com/t5/QlikView/Problem-with-the-expression/m-p/494253#M184878 2013-06-20T18:58:12Z Re: System Monitor App https://community.qlik.com/t5/QlikView/Problem-with-the-expression/m-p/494254#M184879 <HTML><HEAD></HEAD><BODY><P>Anyone?</P></BODY></HTML> Fri, 21 Jun 2013 14:44:20 GMT https://community.qlik.com/t5/QlikView/Problem-with-the-expression/m-p/494254#M184879 2013-06-21T14:44:20Z