Qlik Community

Qlik Sense App Development

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

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 =

If(Num(REPORTING_DATE)=$(=(max(REPORTING_DATE))), REPORTING_DATE, null)

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
thomaslg_wq
Contributor III

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

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

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

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

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

Community Browser