topic Re: Show two dimensions on x-axis of a chart in QlikView

Show two dimensions on x-axis of a chart

Sun, 26 Feb 2012 15:22:17 GMT

Hi,

Is ther any way to show two dimension(For eg, Year and Quarter) both on x-axis of a bar chart?

Show two dimensions on x-axis of a chart

Sun, 26 Feb 2012 16:40:25 GMT

Hi Kakarottoo

In a normal bar chart, if you have 2 dimensions qlikview will compare them side by side, either stacked or grouped in different colours.

If you add a third dimension, however, qlikview will show the first two on the x axis. In the image below I ahve added a third "dummy" dimension where the calculation is "=1" and this forces the year and month onthe the x axis

Is this what you need?

Regards,

Erica

Show two dimensions on x-axis of a chart

Anonymous — Mon, 11 Jun 2012 11:36:51 GMT

is it possible to get different colors on the bars that are grouped? hence, one color for january another one for february etc.?

Re: Show two dimensions on x-axis of a chart

Tue, 12 Jun 2012 18:38:23 GMT

Hi Borgannika

2 ways to do this:

If you remove the dummy dimension, month will no longer be displayed on the X - axis but will return to the legend, meaning each month is a different colour. However there are issues if you have missing data, (will need to display all values, ie not suppressed for 0's)

The alternative is to use the expression list to define a colour depending on the month. In the expression tab, expand the expression that has the bars that you are interested in. under "background colour" enter a formula not dissimilar to:

pick([Month Number],Red(), blue(), lightred().....)

This will take the number of the nth month and match it to the nth colour in the list. EG above, february would be blue

kakarotoo: an alternative is to use "text on Axis" checked as an expression then use that expression to display the month. I completely forgot about this functionality!

Thanks

Erica Whalley

Re: Show two dimensions on x-axis of a chart

udaya_kumar — Thu, 27 Sep 2012 04:50:25 GMT

Hi Erica,

How to hide the values 2010 and 2011 in the chart?

I need to hide the second dimension at the x-axis.

how we can do that?

Re: Show two dimensions on x-axis of a chart

Sat, 18 Oct 2014 21:46:50 GMT

Hi Erica,

Could you please let me know how to add dummy variable ?

Thanks,

Dhawal

Re: Show two dimensions on x-axis of a chart

Wed, 22 Oct 2014 16:39:43 GMT

what if I want to show 3 variables on X-axis , as shown below -

Re: Show two dimensions on x-axis of a chart

Thu, 23 Oct 2014 12:03:23 GMT

Hi Dhawal,

If still relevant...

In the dimension tab there is a button next to the Edit button 'Add Calculated Dimension'. Click on that and enter =1.

It will add the 'dummy' dimension which is a calculated dimension.

Cheers,

Hila.

Re: Show two dimensions on x-axis of a chart

Thu, 23 Oct 2014 15:31:59 GMT

Hi Hila,

Thanks for your reply. I solved that but now I am having problem to show 3 dimensions on X-axis. Please let me know if you know this.

how to show 3 dimensions on x-axis ? As shown b... | Qlik Community

Re: Show two dimensions on x-axis of a chart

Mon, 11 Jan 2016 14:06:06 GMT

hey erica,

i have two fields that i want to show in two charts like yours. is it possible?

thanks a lot!

best

Re: Show two dimensions on x-axis of a chart

manozpph — Mon, 18 May 2020 04:54:26 GMT

Hi, I developed the Bar chart similarly. How can I show the Colors over Two different Categories are Changing with Filters?With Dummy Dimension Colors are not Changing.

Thanks in Advance!!