topic Re: How to pick max date in QlikView

How to pick max date

vinod2086 — Fri, 15 May 2015 08:29:34 GMT

Hi all,

am facing one issue i have created one calculated dimension as new_date based on date and name .

here for single name more than two date's are available in my new_date column it displaying all date's my question is how to take max date value from new_date column.

Thanks in Advance

Re: How to pick max date

Gabriel — Fri, 15 May 2015 08:38:49 GMT

Hi,

Try using

Max(Date(New))

Re: How to pick max date

anbu1984 — Fri, 15 May 2015 08:39:47 GMT

Can you post calculated dimension expr

Re: How to pick max date

Fri, 15 May 2015 08:58:54 GMT

You can use max(date) in the calculated dimension expression and then concatenate it with name.

Thanks

Khushboo

Re: How to pick max date

aapurva09 — Fri, 15 May 2015 09:10:17 GMT

Hi,

If you are able to create that logic in script, you can use this:

Load Name,

max(Date) AS New_Date

Resident Table

GROUPBY Name;

Use New_Date as Dimension, it will give you only one date per Name and that will also be max date for that Name.

Re: How to pick max date

vinod2086 — Fri, 15 May 2015 09:28:59 GMT

Thanks for all replays,

i have changed exp now its working fine

=Aggr(Max([Date]),_ID)