topic Re: x axis -2 dimensions in QlikView

x axis -2 dimensions

josephinetedesc — Fri, 13 Feb 2015 11:06:57 GMT

Hi All

I have a chart which has 2 dimensions on the x axis. I have combined them using =Weeknum(dateSale} & '-'& Location.

however I have been asked if I can show the Weeknum(dateSale) and then have Location also on the x axis rather than coming up as a legend. I have not been able to do this - any hints for what I can try? The idea would be to have the Location as vertical below the date. Not sure if this is possible ...

Re: x axis -2 dimensions

AbhijitBansode — Fri, 13 Feb 2015 12:01:15 GMT

Yes it is possible.

1. Edit the chart and add a second expression with just a value of 0.A new legend will appear.

2. Open the properties and go to the Presentation tab. Deselect the Show Legend option:

To show location as vertical below date:

Edit the properties of the chart and go to the Axes tab. Set the Secondary Dimension Labels to the / option as shown in the following screenshot:

Re: x axis -2 dimensions

josephinetedesc — Sat, 14 Feb 2015 11:04:42 GMT

Thank you it is exactly what I wanted, but i am not surehow to do the "Answered"

Thank you again

Re: x axis -2 dimensions

AbhijitBansode — Mon, 16 Feb 2015 05:18:08 GMT

you will get two buttons at the bottom of my reply like below. you can press on "correct answer" button.