how to achieve the Latest year and month in loaded data

[#1]

Hi Friends,As new to QlikView as it may simple myself not aware of things like Date in QV can any one help on below thing:

ModifiedDate having modified time stamp need to display max(ModifiedDate) in Jan 2015(MMM YYYY)

ModifiedDate

201501

201501

201501

How can we achieve this in a text object?

Tried below expression in Text Object

=date#(Max({1}[ModifiedDate],'MMMYYYY'))

Output Getting is:201501 but this is not expected

Expecting Output is: Jan 2015

[PrashantSangle]

Hi,

Try

date(date#(ModifiedDate,'YYYYMM'),'MMM YYYY')

or

date(ModifiedDate'MMM YYYY')

Or

try with simply MonthNAme(ModifiedDate)

Regards

[#3]

No luck tried with all above solutions not getting desired o/P

[arulsettu]

check this in textbox

=date(date#('201501','YYYYMM'),'MMM YYYY')

[PrashantSangle]

Hi,

Can you post sample file?

Regards

[senpradip007]

You should get your desired result by using

date(date#(ModifiedDate,'YYYYMM'),'MMM YYYY')

expressions as suggested by max dreamer.

Could you please upload sample qvw?

[#7]

Hi Sruthi,

Try this.

Date(Date#(201501,'YYYYMM'),'MMM YYYY')

[#8]

Hi Sruthi,

=max(date(date#(ModifiedDate,'YYYYMM'),'MMM YYYY'))

try this

Regards,

Savi

[jagan]

Hi,

Try like this

LOAD

*,

MakeDate(Left(DateFieldName, 4), Right(DateFieldName))AS Date_Formatted

FROM DataSource;

Now use =Date(Max({1}[Date_Formatted]),'MMM YYYY')

Hope this helps you.

Regards,

Jagan.

[#10]

Thanks for valuable Time Savitha,Jagan yours code worked for me