Skip to main content

Suggest an Idea

Vote for your favorite Qlik product ideas and add your own suggestions.

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

Last Non Empty Value function to enable Semi-Additive Measures

ghaliabed
Partner - Creator
Partner - Creator

Last Non Empty Value function to enable Semi-Additive Measures

Create new functions that enable Last Non Empty querying similar to OLAP cubes to better handle semi additive measures.

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 

 

Currenlty the only way to do this is a have a specific set expression per Calendar property ex for Year

 

        Sum // YEAR LEVEL
        (
            Aggr
            (
                If
                (
                    [Year Month Number] = Max(TOTAL <[Fiscal Year]> [Year Month Number]), 
                    Sum(ClosingAmount)
                ), 
                [Fiscal Year], [Quarter Year], [Year Month Number], FACTTABLE_UNIQUE_KEY
            )
        )

 

 

 

Tags (2)
4 Comments
John_Teichman
Former Employee
Former Employee

Hello @ghaliabed,

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 submission guidelines for more details. 

Ian_Crosland
Employee
Employee
 
Status changed to: Open - Collecting Feedback
Meghann_MacDonald

From now on, please track this idea from the Ideation portal. 

Link to new idea

Meghann

NOTE: Upon clicking this link 2 tabs may open - please feel free to close the one with a login page. If you only see 1 tab with the login page, please try clicking this link first: Authenticate me! then try the link above again. Ensure pop-up blocker is off.

Ideation
Explorer II
Explorer II
 
Status changed to: Closed - Archived