Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

Not applicable

Month Year Format

Hi all,

I am using below load script,

Month(weekend(CanonicalDate)) as MonthPeriod,

This will print only the month name as 'NOV'

But i need like Nov-15.

So i used

Month(weekend(CanonicalDate)) & '-' & Year(CanonicalDate,'YY') as MonthPeriod

But not working.

Help on this.

Regards,

Kumar

Tags (1)
5 Replies

Re: Month Year Format

Try below

Date(MonthStart(weekend(CanonicalDate)),'MMM-YY') as MonthPeriod

MVP
MVP

Re: Month Year Format

MonthName(CanonicalDate) ?

sat_tok52
Contributor

Re: Month Year Format

Date(MonthStart(CanonicalDate),'MMM-YY')

umartareen
Contributor

Re: Month Year Format

Hi,

You can use

Monthname(CanonicalDate) as FieldName

saumyashah90
Valued Contributor

Re: Month Year Format

as tresesco mentioned:

MonthName(CanonicalDate)  will work

Community Browser