topic Bar graph with Month as static x axis dimension in QlikView

Bar graph with Month as static x axis dimension

Wed, 05 Oct 2011 10:15:16 GMT

Hi All,

In the attached sample QVW, I have created a bar chart with two dimensions (month, year) and a expression. When I select a particular month, the graph shows value for that one month. But what I want is to have a static x axis always showing months Jan to Dec weather data is present or not.

I have use 'Show all values' for month and also 'Continious' and static min/max/step (1/12/1) )values for dimension axis. But it is not working.

Could you please help me on how this can be achieved?

Regards,

Murali

Bar graph with Month as static x axis dimension

jonathandienst — Wed, 05 Oct 2011 10:23:13 GMT

Murali

Have you switched off Suppress Zero Values on the presentation tab of the chart?

Regards

Jonatha

Bar graph with Month as static x axis dimension

Wed, 05 Oct 2011 10:25:34 GMT

Jonatha,

I tried that but no luck.

Regards,

Murali

Re: Bar graph with Month as static x axis dimension

lironbaram — Wed, 05 Oct 2011 10:28:49 GMT

hei attach is an example

it uses Set analysis

hope its helps you

Re: Bar graph with Month as static x axis dimension

Wed, 05 Oct 2011 10:30:21 GMT

Liron,

In your example, when I select a month it is highlighting the month values to Green but other month values are unchanged.

What I want is, when I select a month say July, it should show july values as they are and rest all months should not have any bars. This is because the selected month is July.

Regards,

Murali

Re: Bar graph with Month as static x axis dimension

Anonymous — Wed, 05 Oct 2011 10:52:04 GMT

See attached file:

Re: Bar graph with Month as static x axis dimension

Anonymous — Wed, 05 Oct 2011 10:54:27 GMT

It looks like Liron and I were working on the same idea 🙂

It changes the color and I set the color of the ones that are not selected to white.

Re: Bar graph with Month as static x axis dimension

Wed, 05 Oct 2011 11:06:38 GMT

Dennis,

Thanks for your solution.

It meets my requirement but its a work around. The issue I have over here is that I can have more than 2 years in this graph also changing this to white doesn't help as for me the graph background is a image.

Can't this be achieved using the chat properties like 'Continious', static min/max/step and 'show all vaues' ?

Regards,

Murali

Re: Bar graph with Month as static x axis dimension

Anonymous — Wed, 05 Oct 2011 11:21:00 GMT

I couldn't find it in the properties.

What you could do (an other work around yes 🙂 ) not set the colour to white but set it to 100% transparent.

Re: Bar graph with Month as static x axis dimension

Wed, 05 Oct 2011 11:26:46 GMT

Unfortunately for me color change (100% transparent) is not going to work.

For example when I select december in the legends area, it is showing both 2010 and 2011 where as 2011 with 'White' color. As per the data it shouldn't show any legend for 2011.

Re: Bar graph with Month as static x axis dimension

Mon, 10 Oct 2011 11:08:34 GMT

HI,

Please see the attached file .i hope this will help you

Thanks

Vivek

Re: Bar graph with Month as static x axis dimension

Thu, 13 Oct 2011 16:12:41 GMT

Thanks Vivek.

That was very helpful. After that I ran into another problem. This is what the issue is.

1. I have two tables in my dashboard joined based on a common column.

2. I have created 2 bar graphs display data on both tables.

3. Both tables have missing data for few months in a year.

4. Business always wants to see Jan-Dec in the x-axis.

5. If value is present for that month then the bar should present other wise they need an empty space. In this way they want to keep the x-axis static irrespective of the user selection and data present or not.

Sample QVW is attached.

Could you please help me with this.

Regards,

Murali

Re: Bar graph with Month as static x axis dimension

Tue, 25 Oct 2011 13:40:40 GMT

This is very urgent.

Can any of you please help me with a workaround?

I have also checked this with helpdek and they responsed saying this is the designed QlikView functionality.

Regards,

Murali

Re: Bar graph with Month as static x axis dimension

Anonymous — Wed, 26 Oct 2011 07:49:59 GMT

Hi Murali,

What you need is a master calender that generates your missing dates (in your case missing months)

I add one based one your field [Date]. Take a look and tell me if this is what you are looking for.

Good Luck,

Dennis.