Discussion board where members can get started with QlikView.
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.
May be like this:
MaxString(publishdate) or MaxString(Date#(publishdate))
Try in place of Max you use Maxstring(publishdate)
Create a apply map to get the max date date and add to the main table from the script itself.
If not post sample data to look over.
What is your PublishDate format?
i.e. DD/MM/YYYY or DD-MM-YYYY or something else?
even above mentioned all r not working.. getting calculation error
format is ' DD/MM/YYYY'
Try something like below
can you post sample data?