topic Re: How we can get Last updated Month ? in QlikView

How we can get Last updated Month ?

madhubabum — Mon, 18 Jan 2016 08:04:46 GMT

Hi Experts,

Here we are creating the master calendar for getting yearmonth, Script as following

LOAD

Distinct

timestamp(Monthstart(Key)) as MonthStart,

timestamp(MonthEnd(Key)) as MonthEnd,

Year(floor(Key))&NUM(Month(floor(Key)),'00') as MonthName

Resident tmp_table Order by Last ModifiedDate desc;

OutPut : 201512, 201601

But here i am getting the Last ModifiedDate order of 12 and 01 (Months)

Note : But my Last Updated files are the following

QVD Name Last ModifiedDate

File1.qvd 23-12-2015 10:45:23

File2.qvd 10-01-2016 09:15:30

But, Here i am getting 12 month , But I want to get 01 .....

How we can achieve this scenario, ...any suggestions ?

Thanks in advance,

Madhu

MK_QSL — Mon, 18 Jan 2016 08:59:33 GMT

What is Key here?

nilesh_gangurde — Mon, 18 Jan 2016 09:03:57 GMT

Hi,

Convert the date in the Date Format first using the Date# function if the date is in text form.

and then apply your functions like Year(), Monthname() on the Date Field.

Regards,

Nilesh

sunny_talwar — Mon, 18 Jan 2016 11:14:54 GMT

Not sure I understand what your problem is? For the two qvd files what is your required MonthName?