How to Qlikview select filter max date on real time ?
Anyone knows how to select maximum date by group ? I try to avoid pre-calculating it during load statement, because I want to keep it as interactive as possible. I would like to enable report to recalculate the new max date after user has apply new filtering selection...
I'll take the above scenario as an example and try to explain.
Please note that 'NoDisitinct' can be used only in Aggr function. So here we have to find the max date for a particular Code (dimension) and it should be repeated for all the rows. But if you use Aggr function then Qlikview will create a virtual table like below
Qlikview only shows the date for the first row and rest of the rows as Null for the same code.
So we can use NoDistinct qualifier which helps us to replicate the max date for the same code (dimension).
Finally the output looks like below as per the above requirement.
You can read more about NoDistinct in the below thread.