topic Re: How to set dimensions for x-axis in chart in QlikView

How to set dimensions for x-axis in chart

Mon, 23 Mar 2015 12:47:27 GMT

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

Re: How to set dimensions for x-axis in chart

oknotsen — Mon, 23 Mar 2015 13:52:33 GMT

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?

Re: How to set dimensions for x-axis in chart

Mon, 23 Mar 2015 14:35:20 GMT

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

Re: How to set dimensions for x-axis in chart

Anonymous — Mon, 23 Mar 2015 14:41:29 GMT

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

Re: How to set dimensions for x-axis in chart

Mon, 23 Mar 2015 14:56:35 GMT

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.

Re: How to set dimensions for x-axis in chart

oknotsen — Mon, 23 Mar 2015 18:32:11 GMT

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

Year(Mese) as My_year,

Re: How to set dimensions for x-axis in chart

oknotsen — Mon, 23 Mar 2015 18:33:26 GMT

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.

Re: How to set dimensions for x-axis in chart

oknotsen — Mon, 23 Mar 2015 18:35:39 GMT

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

So, Massimo, take what you like .

Re: How to set dimensions for x-axis in chart

Tue, 24 Mar 2015 10:10:58 GMT

Thanks Onno,

it works perfectly.

Massimo