topic Re: How to Qlikview select filter max date on real time ? in QlikView

How to Qlikview select filter max date on real time ?

bkkuah17 — Wed, 25 Nov 2020 16:16:04 GMT

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

Re: How to Qlikview select filter max date on real time ?

tamilarasu — Tue, 20 Feb 2018 04:09:06 GMT

Hi Steven,

If(Aggr(NODISTINCT Max(B2B.ReqDate),B2B.APPREFNUM)=B2B.ReqDate,'Y','N')

Re: How to Qlikview select filter max date on real time ?

shiveshsingh — Tue, 20 Feb 2018 05:48:56 GMT

Hi Tamil

Can you please let me know why you put

NODISTINCT

Re: How to Qlikview select filter max date on real time ?

tamilarasu — Tue, 20 Feb 2018 06:28:46 GMT

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.

Qlik Tips: No nodistinct

I hope I've explained myself well.

Re: How to Qlikview select filter max date on real time ?

shiveshsingh — Tue, 20 Feb 2018 06:43:59 GMT

Thank you so much for detailed explanation.

Appreciate your efforts

Re: How to Qlikview select filter max date on real time ?

tamilarasu — Tue, 20 Feb 2018 07:26:27 GMT

No Problem .

Re: How to Qlikview select filter max date on real time ?

bkkuah17 — Tue, 20 Feb 2018 09:40:07 GMT

Thanks ! It works..