topic Re: Issue on retrieving the latest month in QlikView

Issue on retrieving the latest month

manoranjan_d — Fri, 08 Jul 2016 05:57:44 GMT

Hi all,

I m using the the below coding, but its not considering to take the value for the LATEST_MONTH FIELD

load

date(DATE,'YYYY') as YEAR,

date(DATE,'MMM') as MONTH,

if(date(DATE,'YYYY')=Year(Today()),date(DATE,'MM')) as LATEST_MONTH

FROM XXX table

tamilarasu — Fri, 08 Jul 2016 06:04:33 GMT

Hi Manioranjan,

Try,

Load

Date(DATE,'YYYY') as YEAR,

Date(DATE,'MMM') as MONTH,

If(Year(DATE)=Year(Today()),date(DATE,'MM')) as LATEST_MONTH

FROM XXX table

manoranjan_d — Fri, 08 Jul 2016 06:13:00 GMT

thnaks got it but , now wht i need is example

2015 have from jan to dec

2016 have from jan to may

they need latest 14 months

so they need as

2016 from jan to may and also they need aug, sep, oct, nov, dec from 2015

so they need latest 14 months?

varshavig12 — Fri, 08 Jul 2016 06:19:08 GMT

Addmonths() can help you for the last 14 months data

tamilarasu — Fri, 08 Jul 2016 06:23:12 GMT

Fine. try like below.

Load

Date(DATE,'YYYY') as YEAR,

Date(DATE,'MMM') as MONTH,

If(DATE >= Monthstart(Addmonths(Today(),-14)),Date(DATE,'MM')) as LAST_14_MONTH,

FROM XXX table;