topic Re: how do we find max date in QlikView

how do we find max date

Wed, 26 Mar 2014 08:05:07 GMT

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.

Re: how do we find max date

Wed, 26 Mar 2014 08:07:54 GMT

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

Re: how do we find max date

PrashantSangle — Wed, 26 Mar 2014 08:08:14 GMT

Hi,

I think you are looking for max()

try this,

=max(dateFieldName)

Regards,

Re: how do we find max date

its_anandrjs — Wed, 26 Mar 2014 08:13:56 GMT

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

Re: how do we find max date

Wed, 26 Mar 2014 08:43:45 GMT

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)

Re: how do we find max date

Wed, 26 Mar 2014 08:45:45 GMT

Hi,

try to use "MaxDate" operator

thank you

Re: how do we find max date

Wed, 26 Mar 2014 09:26:37 GMT

This might give you required output -

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

Re: how do we find max date

sunilkumarqv — Wed, 26 Mar 2014 09:53:56 GMT

create on Calendarday in your script

Load

day(date) as Calendarday

from datasoruce ;

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

Re: how do we find max date

Wed, 26 Mar 2014 10:03:15 GMT

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)