https://community.qlik.com/t5/App-Development/calculate-the-based-on-date-filter-pane-selection/m-p/1775113#M60070 <P>Hello Guys ,</P><P>I have a date filed "date_New"&nbsp; i use in my filter pane&nbsp; i need all results of my report&nbsp; to be calculated by less than or equal this date .</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Zahmed14_2-1610948927283.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/47214iA9C21AC59EE1C602/image-size/medium?v=v2&amp;px=400" role="button" title="Zahmed14_2-1610948927283.png" alt="Zahmed14_2-1610948927283.png" /></span></P><P>My dimension is&nbsp; :&nbsp;=If(aggr(nodistinct max({&lt;Date_New={ "&lt;=$(v_MAX)"} &gt;}Date_New),OBJNR) = Date_New, TXT30)</P><P>My measure is :&nbsp;Count( {&lt; Date_New={ "&lt;=$(v_MAX)"} &gt; } OBJNR)</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 00:48:50 GMT Zahmed14 2024-11-16T00:48:50Z https://community.qlik.com/t5/App-Development/calculate-the-based-on-date-filter-pane-selection/m-p/1775113#M60070 <P>Hello Guys ,</P><P>I have a date filed "date_New"&nbsp; i use in my filter pane&nbsp; i need all results of my report&nbsp; to be calculated by less than or equal this date .</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Zahmed14_2-1610948927283.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/47214iA9C21AC59EE1C602/image-size/medium?v=v2&amp;px=400" role="button" title="Zahmed14_2-1610948927283.png" alt="Zahmed14_2-1610948927283.png" /></span></P><P>My dimension is&nbsp; :&nbsp;=If(aggr(nodistinct max({&lt;Date_New={ "&lt;=$(v_MAX)"} &gt;}Date_New),OBJNR) = Date_New, TXT30)</P><P>My measure is :&nbsp;Count( {&lt; Date_New={ "&lt;=$(v_MAX)"} &gt; } OBJNR)</P><P>&nbsp;</P><P>&nbsp;</P> Sat, 16 Nov 2024 00:48:50 GMT https://community.qlik.com/t5/App-Development/calculate-the-based-on-date-filter-pane-selection/m-p/1775113#M60070 Zahmed14 2024-11-16T00:48:50Z