Skip to main content

App Development

Discussion board where members can learn more about Qlik Sense App Development and Usage.

An issue has been identified on Qlik Cloud hub, please visit our Status Update Page for details: GET THE LATEST
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Most Efficient Way of Showing Max Available Date Only in a Table

I have a rather large table - about 15 dimensions and 10 measures in all, across a few source tables.

I would like to only show data for the latest available Reporting Date dimension, according to the user selections.

Previously I had all 10 measures contain set analysis for the latest date.

However, I wanted to see if there was a more efficient way of doing this?

I tried a calculated dimension, though, I'm unsure if that is much better. It seems to take the same amount of time.

Calc'd dimension I used =


In a lot of blog posts I've read, they warn against using any calculated dimensions. Though, the same posts warn about over using set analysis.

2 Replies
Creator III
Creator III

Set analysis is the better option.

Maybe you could show us your data model, the number of lines,  your final table and the several set analysis expressions, so we could help you improve the overall time response.

Not applicable

Set analysis like this should do the trick for your metrics...

sum({$<[Date] = {'$(=date(Max([Date])))'}>} <Insert Balance Dimm here> )