https://community.qlik.com/t5/App-Development/Fixed-Measure-for-specific-field/m-p/2513527#M105346 <P>Hi everyone,<BR />I am currently working on the display of available time for bots, given the following master measure:<BR /><EM><STRONG>MAX( AGGR( 1-SUM(Hours) / ( COUNT(Day)*24 ) , Bot) )<BR /></STRONG></EM>I will like to set the maximum available time per bot and keep this value when specific bots are selected, I want to be filtereds by day, month or other fields different from Bots.<BR /><BR />Do you know how to achieve this?</P> Tue, 08 Apr 2025 14:17:43 GMT LuisGramillo 2025-04-08T14:17:43Z https://community.qlik.com/t5/App-Development/Fixed-Measure-for-specific-field/m-p/2513527#M105346 <P>Hi everyone,<BR />I am currently working on the display of available time for bots, given the following master measure:<BR /><EM><STRONG>MAX( AGGR( 1-SUM(Hours) / ( COUNT(Day)*24 ) , Bot) )<BR /></STRONG></EM>I will like to set the maximum available time per bot and keep this value when specific bots are selected, I want to be filtereds by day, month or other fields different from Bots.<BR /><BR />Do you know how to achieve this?</P> Tue, 08 Apr 2025 14:17:43 GMT https://community.qlik.com/t5/App-Development/Fixed-Measure-for-specific-field/m-p/2513527#M105346 LuisGramillo 2025-04-08T14:17:43Z https://community.qlik.com/t5/App-Development/Fixed-Measure-for-specific-field/m-p/2513563#M105355 <P>Try this&nbsp;</P><P>MAX(</P><P>&nbsp; AGGR(</P><P>&nbsp; &nbsp; 1 - SUM({&lt;Bot=&gt;} Hours) / (COUNT({&lt;Bot=&gt;} Day)*24),</P><P>&nbsp; &nbsp; Bot</P><P>&nbsp; )</P><P>)</P> Tue, 08 Apr 2025 18:28:17 GMT https://community.qlik.com/t5/App-Development/Fixed-Measure-for-specific-field/m-p/2513563#M105355 Chanty4u 2025-04-08T18:28:17Z