topic Re: Month year Filed in QlikView

Month year Filed

Chanty4u — Wed, 15 Jun 2016 10:38:51 GMT

Hi all,

I am unable to get the values for Monthyear

Below is my script

LOAD *,

Year(date#(Date,'DD-MMM-YY')) as Year,

Month(date#(Date,'DD-MMM-YY')) as Month,

Day(date#(Date,'DD-MMM-YY')) as Day,

Week(date#(Date,'DD-MMM-YY')) as Week,

'Q' & ceil(Num(Month(date#(Date,'DD-MMM-YY')))/3) as Quater,

Dual(Month(Date) & '-' & Date(Date, 'YY'),

Num(Year(Date)) & Num(Month(Date), '00')) AS MonthYear,

//Date(MonthStart(Date), 'MMM-YYYY') as [Month-Year],

i trid abve for that but it is not givng the values?

Re: Month year Filed

sunny_talwar — Wed, 15 Jun 2016 10:40:47 GMT

Why don't you use MonthName() function or Date function?

MonthName(Date) as MonthYear

Date(MonthStart(Date), 'MM-YY') as MonthYear

Re: Month year Filed

sunny_talwar — Wed, 15 Jun 2016 10:42:02 GMT

Date functions are already dual in nature and hence if you use them, you will not have to use Dual function to assign them text and numeric values. Are you looking for a specific format for MonthYear?

Re: Month year Filed

sasiparupudi1 — Wed, 15 Jun 2016 10:42:16 GMT

Date(date#(Date,'DD-MMM-YY') ,'YYYYMM') as YYYYMM,

Re: Month year Filed

Chanty4u — Wed, 15 Jun 2016 10:42:54 GMT

i tried but no use sunny ... same result

Re: Month year Filed

sunny_talwar — Wed, 15 Jun 2016 10:43:39 GMT

It seems like your date isn't interpreted as date, may be this:

MonthName(Date#(Date,'DD-MMM-YY')) as MonthYear

Date(MonthStart(Date#(Date,'DD-MMM-YY')), 'MM-YY') as MonthYear

Re: Month year Filed

Chanty4u — Wed, 15 Jun 2016 10:43:41 GMT

No specific format.... jst i want monthyear field

Re: Month year Filed

sunny_talwar — Wed, 15 Jun 2016 10:44:47 GMT

I would recommend using MonthStart so that Day is normalized to 1 and MonthYear field doesn't repeat in list box

Re: Month year Filed

Chanty4u — Wed, 15 Jun 2016 10:48:17 GMT

thnks sasi .

ur expression is also wrkng same wat i want