https://community.qlik.com/t5/App-Development/How-to-improve-the-expression-to-sum-or-average-measures-over/m-p/1872416#M71977 <P>Hi,</P> <P>Hope to tap your expertise in improving the expression below.</P> <P>I am using the following expression in a straight table to report the inventory value on Sat 12am every week, for the past 6 weeks. In the straight table, each column is one measure for the data in that day for that week.</P> <P>=Sum({&lt;$(vInvDate)={"$(=Date(Weekstart(Max($(vInvDate)), 0, 5)))"}&gt;} TotalInventoryUSD)</P> <P>to</P> <P>=Sum({&lt;$(vInvDate)={"$(=Date(Weekstart(Max($(vInvDate)), -6, 5)))"}&gt;} TotalInventoryUSD)</P> <P>&nbsp;</P> <P>Now I would like to have the average inventory value over the 6 weeks. Instead of add all the 6 sum expression then divided by 6, is there anyway to have a simpler expression to do the same?</P> <P>&nbsp;</P> <P>Thank you in advance.</P> Sat, 16 Nov 2024 16:53:02 GMT A7R3 2024-11-16T16:53:02Z https://community.qlik.com/t5/App-Development/How-to-improve-the-expression-to-sum-or-average-measures-over/m-p/1872416#M71977 <P>Hi,</P> <P>Hope to tap your expertise in improving the expression below.</P> <P>I am using the following expression in a straight table to report the inventory value on Sat 12am every week, for the past 6 weeks. In the straight table, each column is one measure for the data in that day for that week.</P> <P>=Sum({&lt;$(vInvDate)={"$(=Date(Weekstart(Max($(vInvDate)), 0, 5)))"}&gt;} TotalInventoryUSD)</P> <P>to</P> <P>=Sum({&lt;$(vInvDate)={"$(=Date(Weekstart(Max($(vInvDate)), -6, 5)))"}&gt;} TotalInventoryUSD)</P> <P>&nbsp;</P> <P>Now I would like to have the average inventory value over the 6 weeks. Instead of add all the 6 sum expression then divided by 6, is there anyway to have a simpler expression to do the same?</P> <P>&nbsp;</P> <P>Thank you in advance.</P> Sat, 16 Nov 2024 16:53:02 GMT https://community.qlik.com/t5/App-Development/How-to-improve-the-expression-to-sum-or-average-measures-over/m-p/1872416#M71977 A7R3 2024-11-16T16:53:02Z