topic Need a Maximum Date in Fiscal Calender in QlikView

Need a Maximum Date in Fiscal Calender

SatyaPaleti — Mon, 08 Feb 2016 16:51:40 GMT

Hi Friends,

I am having calendar up to date 1/3/2021

I want to Display Maximum Date in Calendar

I am using

Load

Year ,

Max(Date(Date)) as MaximumDate

from

xyz.com

groub by Year;

I am getting out put as Below Mentioned Image

I want to display only 1/3//2021

Can you guys help me with this

Thank you,

Satya

Re: Need a Maximum Date in Fiscal Calender

sunny_talwar — Mon, 08 Feb 2016 16:54:36 GMT

I guess you just need this then:

LOAD Date(Max(Date)) as MaximumDate

from xyz.com;

Re: Need a Maximum Date in Fiscal Calender

harsh44_bhatia — Mon, 08 Feb 2016 17:05:27 GMT

Hello Satya,

The problem with your approach is that the logic scans each row, since here a row is individual group set a date is max for each row, hence you get back all your records.

approach suggested bu Sunny T is good.

you can also try the following as well since you may have many more columns in your table

maxmindate:

load

DATE(min(FieldValue('dateField',RecNo()))) as minDate,

DATE(max(FieldValue('dateField',RecNo()))) as maxDate

AutoGenerate FieldValueCount('dateField');

Re: Need a Maximum Date in Fiscal Calender

sathishkumar_go — Mon, 08 Feb 2016 17:19:25 GMT

In your script, You have used Year and Max(Date) and groupby Year sothat in each year it is showing the maximum date.

If you want only maximum date of the entire calendar?

then try this,

load
Max(Date(Date)) as MaximumDate
resident TableName;

--Sathish