topic Re: how to achieve the Latest year and month in loaded data in QlikView

how to achieve the Latest year and month in loaded data

Mon, 09 Mar 2015 09:58:32 GMT

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

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

Re: how to achieve the Latest year and month in loaded data

PrashantSangle — Mon, 09 Mar 2015 10:01:26 GMT

Hi,

Try

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

date(ModifiedDate'MMM YYYY')

try with simply MonthNAme(ModifiedDate)

Regards

Re: how to achieve the Latest year and month in loaded data

Mon, 09 Mar 2015 10:08:26 GMT

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

Re: how to achieve the Latest year and month in loaded data

arulsettu — Mon, 09 Mar 2015 10:11:18 GMT

check this in textbox

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

Re: how to achieve the Latest year and month in loaded data

PrashantSangle — Mon, 09 Mar 2015 10:11:33 GMT

Hi,

Can you post sample file?

Regards

Re: how to achieve the Latest year and month in loaded data

senpradip007 — Mon, 09 Mar 2015 10:11:43 GMT

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?

Re: how to achieve the Latest year and month in loaded data

Mon, 09 Mar 2015 10:16:11 GMT

Hi Sruthi,

Try this.

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

Re: how to achieve the Latest year and month in loaded data

Mon, 09 Mar 2015 10:17:12 GMT

Hi Sruthi,

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

try this

Regards,

Savi

Re: how to achieve the Latest year and month in loaded data

jagan — Mon, 09 Mar 2015 10:24:50 GMT

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.

Re: how to achieve the Latest year and month in loaded data

Mon, 09 Mar 2015 10:33:02 GMT

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

Re: how to achieve the Latest year and month in loaded data

jagan — Tue, 10 Mar 2015 01:27:40 GMT

Hi Sruthi,

If you got the answer please close this thread by giving correct and Helpful answers.

Regards,

Jagan.