Qlik Community

QlikView Layout & Visualizations

Discussion Board for collaboration on QlikView Layout & Visualizations.

Not applicable

View the X-Axis description in graph

Hello,

 

I have a query trying to make a graph in QlikView.

 

The X-axis of a graph I want to use as the Months of Continuous Dimension

(which the division is for all months) but that only shows the name

of the month every 3 months.

Anyone know how I could do this?

I appreciate your help.

Thank you

9 Replies
mov
Esteemed Contributor III

Re: View the X-Axis description in graph

Most likely there is simply no enough space.  Try using diagonal or vertical lables.

Regards,

Michael

PS: in general, month as continuous is a strange idea...

Not applicable

Re: View the X-Axis description in graph

Hi,

I attached a picture where you can see my goal.

In the picture above is the chart now, and in the bottom picture is how I want.

I could do?

Very thanks,Grafico.jpg

Guzmán

Not applicable

Re: View the X-Axis description in graph

Just like Michael said , the issue is space.

here is what I do - change the axes label to vertical(Under chart properties , Dimension axis, click the radio button corresponds to vertical line) and streach the length. and change the font for axis label.

Hope this helps

Aji.ChartProperties.JPG

rominavilla
New Contributor III

Re: View the X-Axis description in graph

I think he wants to say that just wants to see the information by quarter. I mean, for the corresponding to january, february and march, appears accumulated in january. The same for the rest of the months.

Not applicable

Re: View the X-Axis description in graph

From the image Guzmán uploaded , the graphs looks same(I mean no data aggregation ) . So I guess he wants the label to be displayed for every month

mov
Esteemed Contributor III

Re: View the X-Axis description in graph

Aji,
As i can see now it is quite opposite.  Current version shows all months, and the requirement is to show only hte 1st month of the quarter - but the data points must be for all months.

Guzmán,

See what I tried - and got some result.
First step is to create an artificial dimension that has "normal" value for the 1st months of the quarter, and value that contains blanks, and character chr(10) at the start and the end, for all other months.  To make each "month" unique, I used different number of blanks.  Here is the script of the data, see Month1 field:

// Date =====================================
LET Start = num(makedate(2010,1,1));
LET End = floor(yearend(today()));

Date:
LOAD
$(Start)-1+RecNo() as Date
AUTOGENERATE $(End) - $(Start) + 1;
JOIN (Date) LOAD
Date,
date(MonthStart(Date), 'MMM-YY') as Month,
year(Date) as Year
RESIDENT Date;

tmp:
LOAD DISTINCT
Month
RESIDENT Date;

JOIN (Date) LOAD DISTINCT
Month,
if(mod(month(Month),3)=1,date(MonthStart(Month), 'MMM-YY'), chr(10)& repeat(' ', RowNo()) & chr(10)) as Month1
RESIDENT tmp
ORDER BY Month;

DROP TABLE tmp:
// ==================================

Field Month1 is what we need for the chart as dimension.  It looks more or less OK if use vertical labels, not continuous.  And, in Presentations limit legend (characters) to 6.

Regards,
Michael

Not applicable

Re: View the X-Axis description in graph

Michael, Now it make sense :-) My bad I didn't read it correctly

Not applicable

Re: View the X-Axis description in graph

Hi

As Michael says, I want to show the division for all the months but only the description of the scale for the first month of the quarter

Michael,

Very thanks for your response.

I tried what you said but did not get the expected result, in the following image is the graph as it was then.

Grafico2.jpg

Regards.

Guzmán

mov
Esteemed Contributor III

Re: View the X-Axis description in graph

Guzmán,

Looks like the chart expressions are not logicaly related to the Date table.  Can't guess more than that from the picture.

Regards,

Michael

Community Browser