how do we find max date

[#1]

i need to show only max date in a month and the sales on that day.

how to find max date ? like the sales been till 29th of march so how do we tell qlikview to show only max date i.e., 29/03/2014.

[#2]

sum({<SaleDate={max(SaleDate)}>}Sales)

[PrashantSangle]

Hi,

I think you are looking for max()

try this,

=max(dateFieldName)

Regards,

[its_anandrjs]

Hi,

In load if DateField contains max date regularly then use peek function like

Let vMaxDate = Peek('Datefield',-1,'Tablename');

or use

Max(Datefield)

Hope this helps

Thanks & Regards

[#5]

Hi gatikvij09,

Create a variable for max date

Let vMaxDate=Max(SaleDate);

And find sales of max date using set analysis

=sum({<SaleDate={'vMaxDate'}>}Sales)

[#6]

Hi,

try to use "MaxDate" operator

thank you

[#7]

This might give you required output -

=sum({<CalendarDate={"$(=max(CalendarDate))"}>}Sales)

[sunilkumarqv]

  create on Calendarday in your script

Load

day(date) as Calendarday

from datasoruce ;

=sum({<Calendarday= {"$(=max({<Date={$(=max(Date))}>} Calandarday))"}>}Sales)

[#9]

If you are linking to a calendar that projects into the futute then you will have to ensure that it ties up with your sales data.

Add a variable (Ctrl + Alt + V)

Variable vCurrentDate = Date(Max({<SalesReference-=0 > } DateLK), 'DD/MM/YYYY')

Using {<SalesReference-=0 > } will ensure that it pulls back the date from the last sales entry.

The expression would be

=SUM({< DateLK={"$(=vCurrentDate)"} >} CLG_Count)