https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idi-p/1706455 <P>Create new functions that enable Last Non Empty querying similar to OLAP cubes to better handle semi additive measures.</P> <P>Ex, If i have data set of Closing Balances at month level, i want to directly have a single master measure that if grouped by Year or Quarter or Period, and by any other Dimension, to directly show the last Date Period value available&nbsp;</P> <P>&nbsp;</P> <P>Currenlty the only way to do this is a have a specific set expression per Calendar property ex for Year</P> <P>&nbsp;</P> <LI-CODE lang="markup"> Sum // YEAR LEVEL ( Aggr ( If ( [Year Month Number] = Max(TOTAL &lt;[Fiscal Year]&gt; [Year Month Number]), Sum(ClosingAmount) ), [Fiscal Year], [Quarter Year], [Year Month Number], FACTTABLE_UNIQUE_KEY ) )</LI-CODE> <P>&nbsp;</P> <P>&nbsp;</P> <P>&nbsp;</P> Wed, 25 Nov 2020 08:56:29 GMT ghaliabed 2020-11-25T08:56:29Z https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idc-p/1706981#M2319 <P>Hello&nbsp;<a href="https://community.qlik.com/t5/user/viewprofilepage/user-id/31320">@ghaliabed</a>,</P> <P>Thank you for your idea. Going forward, please use one and only one label when submitting an idea. We use the labels to route ideas to the appropriate product manager. Things can get "confused" when there are multiple labels. Please refer to the <A href="https://community.qlik.com/t5/Qlik-Product-Insight-Blog/Submitting-an-Idea/ba-p/1684014" target="_self">submission guidelines</A> for more details.&nbsp;</P> Mon, 01 Jun 2020 03:25:53 GMT https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idc-p/1706981#M2319 John_Teichman 2020-06-01T03:25:53Z https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idc-p/1832868#M7175 Wed, 01 Sep 2021 12:17:57 GMT https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idc-p/1832868#M7175 Ian_Crosland 2021-09-01T12:17:57Z https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idc-p/2113443#M15167 <P>From now on, please track this idea from the Ideation portal.&nbsp;</P><P><STRONG><A title="Link to new idea" href="https://ideation.qlik.com/app/#/case/276469" target="_blank" rel="noopener">Link to new idea</A></STRONG></P><P>Meghann</P><P data-unlink="true"><EM>NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you <STRONG>only</STRONG> see 1 tab with the login page, please try clicking this link first: <STRONG><A title="Authenticate me!" href="#" target="_blank" rel="noopener">Authenticate me!</A></STRONG>&nbsp;t</EM><EM>hen try the link above again. Ensure pop-up blocker is off.</EM></P> Tue, 05 Sep 2023 13:05:13 GMT https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idc-p/2113443#M15167 Meghann_MacDonald 2023-09-05T13:05:13Z https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idc-p/2113444#M15168 Tue, 05 Sep 2023 13:05:14 GMT https://community.qlik.com/t5/Suggest-an-Idea/Last-Non-Empty-Value-function-to-enable-Semi-Additive-Measures/idc-p/2113444#M15168 Ideation 2023-09-05T13:05:14Z