how do I keep a date axis constant on a graph when I make selections on other data?

[#1]

Hi all,

I created a 'date island' which I used to link to the RIM created date returned from one part of my query.

This is fine, when I pick nothing but the Month. For example, if I choose October 2010, I can see on the x-axis, entries from 1st to 31st, whether there is relating data or not.

If I then pick a project reference from the list box, it only shows dates where there are values for that project.

How can I get the graph to constantly show all of a month, regardless of other selections?

does this make sense?

Regards,

Matt

[#2]

nah,

that doesnt do it.

Since the first responses on this thread I have re-introduced the join between the data tables and the 'date/calendar' load.

I chose a 'right keep' join - not sure if that is the right thing to use though.

This is so that users can select a date range and have QlikView filter the other data etc.

I need a two way thing.

I need the data picker to control the data, but also to show graphs with a continuous x-axis (jan-dec) if i dont pick a particular set of months..

i know that some of the clients in my list boxes will only have values in Oct/Nov/Dec for example, but I want the graph to be forced with all months.

Thanks in advance,

Matt

[#3]

Have just attached the latest file.

As you can see, the graph at the top left shows all months.

If I Click the company 'DST UK Internal'

The data reduces, and I miss January, July, august, September, October and December

If I don't actually specify a month, I would like it to return all.

or at least have a continuous range between the min and max for that data set.

Any ideas?

Thanks in advance

Matt

[pover]

Matt,

Here's an example of the graph behaving as you want. However, for some reason the numbers for july, august and september don't match even though the rest of the year looks good.

Regards.

[#5 · Accepted solution]

Life saver!

Thank you so much for this. Its just what I am looking for.

Regards,

Matt

[sunil2288]

Hi Matpj,

If you have got the answer as suggested by Karl...

Why don't you mark it as Verfied...

Thanks,

Sunil

[#7]

I did 😄

[Anonymous]

I've implemented both approaches but the iterno is, IMHO, the better solution.  It has two advantages:

1) Using the 'island' approach, a click on the line chart will set the island dimension to the selected date.  This, therefore, doesn't affect any other charts in your presentation (kind of defeating one of the key advantages of QV)

2) The iterno approach generates charts on the screen much more quickly, especially when a lot of data is involved.

-- Ben

[#9]

Just found this - it solved a problem Th@anks!