Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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...
Below is as far as I can figure out...
Thanks
Steven
Hi Steven,
If(Aggr(NODISTINCT Max(B2B.ReqDate),B2B.APPREFNUM)=B2B.ReqDate,'Y','N')
Hi Steven,
If(Aggr(NODISTINCT Max(B2B.ReqDate),B2B.APPREFNUM)=B2B.ReqDate,'Y','N')
Hi Tamil
Can you please let me know why you put
NODISTINCT
Hi Shivesh,
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.
I hope I've explained myself well.
Thank you so much for detailed explanation.
Appreciate your efforts
No Problem .
Thanks ! It works..