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

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

Mon, 20 Dec 2010 18:17:51 GMT

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

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

pover — Mon, 20 Dec 2010 19:07:30 GMT

Matt,

The "date island" has to be disconnected from the rest of you model and you must use a count(if) as an expression. This will give you what you are looking for although you have to be careful that the time to create the graph doesn't increase dramatically. If you begin to experience long creation times, you might want to experiment with the iterno() function to create a project transaction row for every date since a project's beginning regardless if there is activity o no.

Regards.

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

johnw — Tue, 21 Dec 2010 00:01:11 GMT

Following up on what Karl said, here's an example of filling in missing dates with iterno(), and then how to build a chart that displays 0 for those dates.

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

Wed, 29 Dec 2010 17:27:34 GMT

Thats great, thank you so much, guys.

I have now come up against another problem.

as you can see from the attached QVW. I have created a chart (bar) that shows a stacked view of the breakdown of 'Status' for only 'change' type_codes

However, the legend shows values not associated with CHANGE (the red value of 'resolved') .

You can see this is removed when you physicially select 'CHANGE' from the list box along the top of the page.

Is there anyway I can have the graph not include this, but STILL include ALL months along the axis (have played with supress missing/zero etc - but it sacrifices the months)

thanks in advance,

Matt

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

pover — Wed, 29 Dec 2010 18:43:32 GMT

Matt,

In the dimension tab, change the STATUS_CODE dimension to something like this:

=if(MATCH(STATUS_CODE,'RESOLVED'),NULL(),STATUS_CODE)

The RESOLVED value than will be elminated from the graph.

Regards.

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

Thu, 30 Dec 2010 09:33:36 GMT

Thanks Karl,

although that just replaces 'RESOLVED' in the legend with '-'

I want a way of removing it from the legend all together :-S

anyone have any other ideas?

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

Thu, 30 Dec 2010 10:32:30 GMT

Tick the 'Suppress when value is null' checkbox

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

Thu, 30 Dec 2010 10:47:00 GMT

d'oh!

its always the simple/easy things that get overlooked...

thanks for reminding me 😄

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

Thu, 30 Dec 2010 16:26:16 GMT

Going back to my attachment.

Is there a way I can keep the date island independant, so that I get the full Jan - december on my x-axis all the time,

AS WELL as be able to pick a month and have that to filter my loaded data?

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

pover — Sun, 02 Jan 2011 17:49:17 GMT

Try to tick the "Show all values" option for the Month dimension in the Dimension tab.

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

Tue, 04 Jan 2011 00:59:46 GMT

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

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

Tue, 04 Jan 2011 12:55:25 GMT

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

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

pover — Tue, 04 Jan 2011 23:58:22 GMT

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.

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

Wed, 05 Jan 2011 09:54:06 GMT

Life saver!

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

Regards,

Matt

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

sunil2288 — Wed, 05 Jan 2011 10:12:00 GMT

Hi Matpj,

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

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

Thanks,

Sunil

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

Wed, 05 Jan 2011 11:40:20 GMT

I did 😄

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

Anonymous — Thu, 12 May 2011 19:47:05 GMT

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

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

Fri, 29 Nov 2013 09:42:09 GMT

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