topic YTD Problem in QlikView https://community.qlik.com/t5/QlikView/YTD-Problem/m-p/204129#M61166 <HTML><HEAD></HEAD><BODY><P>Folks,</P><P>I posted this problem earlier but my post wasn't particularly clear.</P><P>I have a KPI calculation which involves a count as per below</P><P>IF([Incident Category]='RTA',((Count (DISTINCT [V.I.R. Number]) / (sum([Scheduled Miles Value]))</P><P>This works perfectly on a monthly basis but I am unable to get this to work on a YTD basis.</P><P>I have a flag system in place for my YTD calcs, (Met Pd) is our refernce for month. But I am unable to adapt the formula with the KPI calc to give me the result I want.</P><P>=sum({$&lt;[Met Pd]={"&gt;=$(#v1Mth) &lt;=$(#v2Mth)"}&gt;} CurYTDFlag).</P><P>I would appreciate any help with this.</P><P>Many Thanks</P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /></BODY></HTML> Mon, 28 Jun 2010 09:48:05 GMT 2010-06-28T09:48:05Z YTD Problem https://community.qlik.com/t5/QlikView/YTD-Problem/m-p/204129#M61166 <HTML><HEAD></HEAD><BODY><P>Folks,</P><P>I posted this problem earlier but my post wasn't particularly clear.</P><P>I have a KPI calculation which involves a count as per below</P><P>IF([Incident Category]='RTA',((Count (DISTINCT [V.I.R. Number]) / (sum([Scheduled Miles Value]))</P><P>This works perfectly on a monthly basis but I am unable to get this to work on a YTD basis.</P><P>I have a flag system in place for my YTD calcs, (Met Pd) is our refernce for month. But I am unable to adapt the formula with the KPI calc to give me the result I want.</P><P>=sum({$&lt;[Met Pd]={"&gt;=$(#v1Mth) &lt;=$(#v2Mth)"}&gt;} CurYTDFlag).</P><P>I would appreciate any help with this.</P><P>Many Thanks</P><P></P><P></P><P></P><P></P><P></P><P></P><BR /><BR /></BODY></HTML> Mon, 28 Jun 2010 09:48:05 GMT https://community.qlik.com/t5/QlikView/YTD-Problem/m-p/204129#M61166 2010-06-28T09:48:05Z