topic Show only dates in chart which are a Friday when Date selected in QlikView https://community.qlik.com/t5/QlikView/Show-only-dates-in-chart-which-are-a-Friday-when-Date-selected/m-p/215624#M69040 <HTML><HEAD></HEAD><BODY><P></P><P></P><BR /><BR /> <P>I am trying to create a chart that will only shwo the dates which are Firdays when a specific date is selected.</P><P>I have started with</P><P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P>SUM({$&lt;[BUSINESS_DATE]={$(= WeekDay ( BUSINESS_DATE)=4 &amp;'&lt;='&amp;DATE((MAX(BUSINESS_DATE)))&amp;'"')}&gt;} [CREDIT_BALANCE])</P><P>It does not return any data</P><P>Thanks</P><P>Alan</P></BODY></HTML> Thu, 15 Apr 2010 18:25:14 GMT alan_grn 2010-04-15T18:25:14Z Show only dates in chart which are a Friday when Date selected https://community.qlik.com/t5/QlikView/Show-only-dates-in-chart-which-are-a-Friday-when-Date-selected/m-p/215624#M69040 <HTML><HEAD></HEAD><BODY><P></P><P></P><BR /><BR /> <P>I am trying to create a chart that will only shwo the dates which are Firdays when a specific date is selected.</P><P>I have started with</P><P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P></P><P></P><BR /><BR /> <P>SUM({$&lt;[BUSINESS_DATE]={$(= WeekDay ( BUSINESS_DATE)=4 &amp;'&lt;='&amp;DATE((MAX(BUSINESS_DATE)))&amp;'"')}&gt;} [CREDIT_BALANCE])</P><P>It does not return any data</P><P>Thanks</P><P>Alan</P></BODY></HTML> Thu, 15 Apr 2010 18:25:14 GMT https://community.qlik.com/t5/QlikView/Show-only-dates-in-chart-which-are-a-Friday-when-Date-selected/m-p/215624#M69040 alan_grn 2010-04-15T18:25:14Z