Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

More than a year at X-Axis

Hello,

I have a table with dates and quantities for N years.

But i need to plot a chart, when on X-Axis is like:

jan-2010 | Feb-2010 | Mar-2010....... | Jan-2011| Feb-2011 | Mar-2011 and so on...

Can anyone help me?

Thank you

1 Solution

Accepted Solutions
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes,

create a field YeaMonth, associate to your date field, and format it the way you want:

load

     Date,

     date(MonthStart(Date), 'MMM-YY') as YearMonth,

     ...

and use YearMonth as a dimension

Oleg Troyansky

View solution in original post

2 Replies
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Yes,

create a field YeaMonth, associate to your date field, and format it the way you want:

load

     Date,

     date(MonthStart(Date), 'MMM-YY') as YearMonth,

     ...

and use YearMonth as a dimension

Oleg Troyansky

vijay_iitkgp
Partner - Specialist
Partner - Specialist

Hi ,

You can use Monthname function as Monthanme(Date). It will five you yearmonth.

Regards

VIjay