Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Highlighted
Not applicable

how can i get latest date(Max Date) in my date column

Hi Guys,

i have a publish date() column.. in that  each  id have multiple dates. but i   need to show up only latest publish date in my table.

how can i get latest date  in my table. when i used  max(publishdate)  am not getting.

please help me out.

12 Replies
Not applicable

Re: how can i get latest date(Max Date) in my date column

Hi,

May be like this:

MaxString(publishdate) or MaxString(Date#(publishdate))

Re: how can i get latest date(Max Date) in my date column

Try in place of Max you use Maxstring(publishdate)

Regards

Anand

Not applicable

Re: how can i get latest date(Max Date) in my date column

Hi,

Create a apply map to get the max date date and add to the  main table from the script itself.

Regards,

Sijo

Re: how can i get latest date(Max Date) in my date column

Hi,

try Maxstring(publishdate).

If not post sample data to look over.

Regards

ASHFAQ

MVP
MVP

Re: how can i get latest date(Max Date) in my date column

What is your PublishDate format?

i.e. DD/MM/YYYY or DD-MM-YYYY or something else?

Not applicable

Re: how can i get latest date(Max Date) in my date column

even  above mentioned all r not working..  getting calculation error

MaxString(publishdate) or MaxString(Date#(publishdate))



Not applicable

Re: how can i get latest date(Max Date) in my date column

format is  ' DD/MM/YYYY'

MVP
MVP

Re: how  can i  get   latest date(Max Date) in my date column

Try something like below

=Max(Date(Date#(publishdate,'DD/MM/YYYY')))

Re: how  can i  get   latest date(Max Date) in my date column

HI,

can you post sample data?

Regards

ASHFAQ