How to set dimensions for x-axis in chart

[#1]

I have a table which represents the quantities of sold product for each month in different years from 2010 up to 2014

I would like to have in QV the same chart I have with excel

but what I can have is like the below example

where there is not a single line but it is referred to each month.

My set is:

dimensions:

Year

Month

expression:

=SUM({<My_year=,My_month=>} Quantità)

by using the set analysis.

How can I have something like excel chart?

Thanks

Massimo

[oknotsen]

I would suggest to create a YearMonth field in the script and use that in your chart instead.

Add this to your MasterCalendar (or any table you are using the date from):

Date(MonthStart (DateField), 'MMM-YYYY') as MonthYear,

Would that work for you?

[#3]

Dear Onno,

In my script I set the below:

LOAD

Month(Mese) as My_month,
Year(Mese) as My_year,

since Mese is stated as JAN-2014, FEB-2014, etc.

Where and how I can use your suggest?

I apologise for that but I am not an expert.

Thanks in advance

[Anonymous]

use Month(Mese) & '-' & Year(Mese) as MonthYear in your script.

[#5]

Hi,

Can you please try loading an extra column as

date#(MESE&'-'ANNO ,'MMM-YYYY') AS [MON-YYYY]

and using that column in the chart.

[oknotsen · Accepted solution]

Month(Mese) as My_month,
Date(MonthStart (Mese), 'MMM-YYYY') as MonthYear,

Year(Mese) as My_year,

[oknotsen]

What Zeeshanuddin suggests would be a calculated dimension.

Calculated dimensions are bad for performance, so if you have the choice to add the MonthYear field to your script and use that instead, it would be better for performance.

[oknotsen]

That would result in month numbers instead of month abbreviations (the 3 letters).

So, Massimo, take what you like .

[#9]

Thanks Onno,

it works perfectly.

Massimo