topic Limited dimension axis in a line chart in QlikView

Limited dimension axis in a line chart

Tue, 20 Dec 2011 08:10:13 GMT

I have an apparently unescplicable problem

As you can see form the image below, I have two line charts which dispalys some data. In this image i have selected only one month (november, as higlited top right in the image) and it all works correctly.

But if I select more months, like for example all the three that i can (Sept, Oct and Nov), here it's what i get:

In the left graph the X-axis stops at 12 november, and in the right one it stops at 18

But as you could see before, i have all the november data loaded

I really cannot figure out what's the problem...

Hope that someone can help me

Thanks in advance,

Maikol

Limited dimension axis in a line chart

swuehl — Tue, 20 Dec 2011 15:08:15 GMT

I think there is limitation on shown data points in a line chart.

Try checking the option "continuous" for the dimension axis on axis tab. You may need to format the continuous axis on number tab accordingly.

Hope this helps,

Stefan

Limited dimension axis in a line chart

Tue, 20 Dec 2011 15:55:04 GMT

What do you mean with "format the continuous axis on number tab"?

I see there is such tab, and i see my "Continuous X-axis". I have tried setting it to Date, but the graph doesn't work ("no numeric values on x-axis")

I don't really understand what this tab is used for..

What should I set?

Limited dimension axis in a line chart

swuehl — Tue, 20 Dec 2011 16:05:03 GMT

I assumed that you are using a date type value with numerical representation, formatted with Date() function to a text representation like you want (e.g. 'D MMM' to get something like '1 Sep').

How have you created your values?

Limited dimension axis in a line chart

Tue, 20 Dec 2011 16:28:49 GMT

The value used as X-axis is defined this way:

Day(LPAC_DAT_LETT)&' '&month(LPAC_DAT_LETT) as Periodo

where LPAC_DAT_LETT is a date filed in my DB

so for example i get "7 Nov" fot the 7th of November

Limited dimension axis in a line chart

swuehl — Tue, 20 Dec 2011 16:33:08 GMT

Try using

Date(LPAC_DAT_LETT, 'D MMM') as Periodo

This should format your dates in the wanted way, like "7 Nov", but will keep the numerical date representation also, thus allowing a continuous axis (in my opinion, it is always better to do it that way, so you could still use all the date time functions and you can calculate on dates also (add, subtract))

Limited dimension axis in a line chart

Wed, 21 Dec 2011 07:44:35 GMT

Great! It works 😃

But there's one small thing i still don't understand:

This way i get the "7 Nov" format if i have no selection, but i get the dd.mm.yyy format if i select just one month

Is this expected?

Limited dimension axis in a line chart

swuehl — Wed, 21 Dec 2011 10:11:55 GMT

Interesting.

For some reason, QV will not regard the format set in number tab for the continuous axis but the standard date format. Seems that is somehow dependent on the range of dimension values to be shown (I just set up a small sample and the change in formatting takes place somewhere between selecting 3-4 months).

To me, it seems like a bug (and the only workaround seems to be setting the standard date format to 'D MMM' too, not sure if this is feasible solution).

Limited dimension axis in a line chart

Wed, 21 Dec 2011 10:51:33 GMT

Ok now it all works perfectly (Setting the standard date format)

Many thanks for all the suggestions!