https://community.qlik.com/t5/App-Development/Showing-date-where-goal-is-met/m-p/1582415#M42583 <P>Hello Everyone,</P><P>I am trying to add a field(s) to a table visualization that captures the "days in" and "date" where an internal goal was met. Lets say the "goal" is a dimension and the "event" is an aggregation where the formula is:</P><P>count({&lt;event_type={15,16}&gt;}event_type)</P><P>&nbsp;</P><P>I need the date when&nbsp;count({&lt;event_type={15,16}&gt;}event_type) &gt; goal. Plus I can't have it change the next time the app loads.</P><P>&nbsp;</P><P>For "days in", I use:</P><P>TODAY() - start_date</P><P>&nbsp;</P><P>I also need the "days in" associated with the "date" above that the goal is reached.&nbsp;</P><P>The desired output would be:</P><P><STRONG>segment&nbsp; &nbsp; &nbsp; &nbsp;start_date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; goal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; event_total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;days_in&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date&nbsp;</STRONG> &nbsp; &nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5/1/19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/8/19</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/1/19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 498&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3/1/19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3/31/19</P><P>&nbsp;</P><P>I appreciate any help.</P><P>Thanks,</P><P>Ben</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 May 2019 19:39:56 GMT BPetosa 2019-05-20T19:39:56Z https://community.qlik.com/t5/App-Development/Showing-date-where-goal-is-met/m-p/1582415#M42583 <P>Hello Everyone,</P><P>I am trying to add a field(s) to a table visualization that captures the "days in" and "date" where an internal goal was met. Lets say the "goal" is a dimension and the "event" is an aggregation where the formula is:</P><P>count({&lt;event_type={15,16}&gt;}event_type)</P><P>&nbsp;</P><P>I need the date when&nbsp;count({&lt;event_type={15,16}&gt;}event_type) &gt; goal. Plus I can't have it change the next time the app loads.</P><P>&nbsp;</P><P>For "days in", I use:</P><P>TODAY() - start_date</P><P>&nbsp;</P><P>I also need the "days in" associated with the "date" above that the goal is reached.&nbsp;</P><P>The desired output would be:</P><P><STRONG>segment&nbsp; &nbsp; &nbsp; &nbsp;start_date&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; goal&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; event_total&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;days_in&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;date&nbsp;</STRONG> &nbsp; &nbsp;</P><P>1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5/1/19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 1000&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 7&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/8/19</P><P>2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 5/1/19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;500&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 498&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;-</P><P>3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 3/1/19&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 200&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; 30&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;3/31/19</P><P>&nbsp;</P><P>I appreciate any help.</P><P>Thanks,</P><P>Ben</P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Mon, 20 May 2019 19:39:56 GMT https://community.qlik.com/t5/App-Development/Showing-date-where-goal-is-met/m-p/1582415#M42583 BPetosa 2019-05-20T19:39:56Z