topic Display only month ends in a graph. in QlikView https://community.qlik.com/t5/QlikView/Display-only-month-ends-in-a-graph/m-p/169551#M40323 <HTML><HEAD></HEAD><BODY><P>I have a list of balances that is laoded each day.</P><P>I am trying to display in a chart only those balances as at month end.</P><P>I have started with this which will give me all the balances. I want to restrict this to month end dates only.</P><P style="font-weight: bold"></P><P style="font-weight: bold">SUM({$&lt;[Business Date]={$(='"&lt;='&amp;DATE(MAX([Business Date]))&amp;'"')}&gt;} [Balance])</P><BR /><BR /> <P></P><P></P></BODY></HTML> Fri, 05 Mar 2010 10:39:39 GMT alan_grn 2010-03-05T10:39:39Z Display only month ends in a graph. https://community.qlik.com/t5/QlikView/Display-only-month-ends-in-a-graph/m-p/169551#M40323 <HTML><HEAD></HEAD><BODY><P>I have a list of balances that is laoded each day.</P><P>I am trying to display in a chart only those balances as at month end.</P><P>I have started with this which will give me all the balances. I want to restrict this to month end dates only.</P><P style="font-weight: bold"></P><P style="font-weight: bold">SUM({$&lt;[Business Date]={$(='"&lt;='&amp;DATE(MAX([Business Date]))&amp;'"')}&gt;} [Balance])</P><BR /><BR /> <P></P><P></P></BODY></HTML> Fri, 05 Mar 2010 10:39:39 GMT https://community.qlik.com/t5/QlikView/Display-only-month-ends-in-a-graph/m-p/169551#M40323 alan_grn 2010-03-05T10:39:39Z