topic Measure expressions that calc using select dim ranges in App Development https://community.qlik.com/t5/App-Development/Measure-expressions-that-calc-using-select-dim-ranges/m-p/1057102#M16854 <HTML><HEAD></HEAD><BODY><P>I've got two tables that are joined by a key.&nbsp; One table has events the other dates.&nbsp; The dates table is the dimension and the events table is used to calculate the measure.&nbsp; The measure I want to calculate is events per day.&nbsp; Such that, if the user selects 7 days and 7 events happened during that 7 day period the measure would be 1 event / day.&nbsp; The problem that I've run into is that if no events occurred until the 7th and final day my metric calculates out to 7 events per day because only one day had a corresponding record in the dates table.&nbsp; The first 6 days had no events and were excluded from the denominator.&nbsp; Here's the expression I was trying to use.&nbsp; <STRONG> max([Event Date]) - min([Event Date]) What I really need is </STRONG><STRONG>the max(<EM>selected value from date table</EM>) - min(<EM>selected value from date table</EM>)</STRONG></P><P><STRONG><BR /></STRONG></P><P>Any help here would be greatly appreciated!</P></BODY></HTML> Wed, 17 Feb 2016 17:59:34 GMT 2016-02-17T17:59:34Z Measure expressions that calc using select dim ranges https://community.qlik.com/t5/App-Development/Measure-expressions-that-calc-using-select-dim-ranges/m-p/1057102#M16854 <HTML><HEAD></HEAD><BODY><P>I've got two tables that are joined by a key.&nbsp; One table has events the other dates.&nbsp; The dates table is the dimension and the events table is used to calculate the measure.&nbsp; The measure I want to calculate is events per day.&nbsp; Such that, if the user selects 7 days and 7 events happened during that 7 day period the measure would be 1 event / day.&nbsp; The problem that I've run into is that if no events occurred until the 7th and final day my metric calculates out to 7 events per day because only one day had a corresponding record in the dates table.&nbsp; The first 6 days had no events and were excluded from the denominator.&nbsp; Here's the expression I was trying to use.&nbsp; <STRONG> max([Event Date]) - min([Event Date]) What I really need is </STRONG><STRONG>the max(<EM>selected value from date table</EM>) - min(<EM>selected value from date table</EM>)</STRONG></P><P><STRONG><BR /></STRONG></P><P>Any help here would be greatly appreciated!</P></BODY></HTML> Wed, 17 Feb 2016 17:59:34 GMT https://community.qlik.com/t5/App-Development/Measure-expressions-that-calc-using-select-dim-ranges/m-p/1057102#M16854 2016-02-17T17:59:34Z Re: Measure expressions that calc using select dim ranges https://community.qlik.com/t5/App-Development/Measure-expressions-that-calc-using-select-dim-ranges/m-p/1057103#M16855 <HTML><HEAD></HEAD><BODY><P>Is event date not equal to date from date table? I am not sure I am understanding your question. Can you elaborate and if possible share a sample?</P></BODY></HTML> Wed, 17 Feb 2016 18:34:18 GMT https://community.qlik.com/t5/App-Development/Measure-expressions-that-calc-using-select-dim-ranges/m-p/1057103#M16855 sunny_talwar 2016-02-17T18:34:18Z