Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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
MVP
MVP

More than a year at X-Axis

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

2 Replies
MVP
MVP

More than a year at X-Axis

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
Valued Contributor

More than a year at X-Axis

Hi ,

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

Regards

VIjay

Community Browser