Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Date format

Hi

In my Cease MonthYear table having like this:

Cease MonthYear

40544

40575

40603

I write in my scrip

month(Num#([Cease MonthYear],'MM-YYYY')) as [Cease MonthYear],

byt it display only month Jan, Feb.....

I want Jan 2011, Feb 2011.... like this how can i get it?

Thanks

Madhu

1 Solution

Accepted Solutions
tresesco
MVP
MVP

Date([Cease MonthYear],'MMM-YYYY') as [Cease MonthYear],

Or,

MonthName([Cease MonthYear]) as [Cease MonthYear],

View solution in original post

1 Reply
tresesco
MVP
MVP

Date([Cease MonthYear],'MMM-YYYY') as [Cease MonthYear],

Or,

MonthName([Cease MonthYear]) as [Cease MonthYear],

View solution in original post