problems with the scale on x-axis

[#1]

Hi there

I built up a linechart about the Net Sales of my company (expressions) and with the dimension "Date" .

The problem is, that the graph isn`t able to show the hole timeperiod on the x-axis, due to space restriction on my sheet. Unfortunately, it cuts out the most recent data instead of either the oldest one or to minimize the graph.

Exp: it shows data from September 2009 until November 2010 instead until today.

Idea 1: show data from MM.YYYY until today

Idea 2: show September 2009 until today (and minimize the graph)

As I am a new user in QlikView with no experience with BI systems and with no help within the company, I am very lost.

Does someone has an idea how to solve that?

Kind regards

Julia

[#2]

Did you change the ID of the chart in the macro? You get the object ID from chart properties>General.

You will only see the result if you save and close the QV document and then go back in to it - did you do so?

I have attached a test document t1 which uses the technique and works OK (created under v9sr4)

Hope this helps!

Gordon

[#3]

Yes, it works! I´m so glad. I did not close and reopen the document! That was the reason!

Great, Thank you so much Gordon!

Best regards

Julia