topic Re: Changing x-axis in cyclic group in QlikView

Changing x-axis in cyclic group

Thu, 07 Nov 2013 20:07:17 GMT

Hello,

I would like to be able to change the x-axis in my cyclic group chart. I have 3 different charts. One with an x-axis of months, another with days, and another with hours. Both Months and Days are concrete figures (ex. 1, 2, 3.... etc.) but hours are grouped (ex. 0-4, 4-8... etc.). My Months and Days charts are both plotting every day or month, so my x-axis is really long. How can I reduce it to where it counts by 5 or 10?

Re: Changing x-axis in cyclic group

Anonymous — Thu, 07 Nov 2013 21:25:46 GMT

Kevin

Have a look at this Resource

http://community.qlik.com/docs/DOC-4311

It could well give you some food for thought.

Best Regards, Bill

Re: Changing x-axis in cyclic group

Fri, 08 Nov 2013 05:47:12 GMT

Hi,

Kevin try to use scroll in the x axis so you can limit the no of values shown at a time

Go to the Properties->Presentation->Chart Scrolling->Click on check box near Enable x axis scrollbar->Specify the no of bars . This shows all the bars in the chart just controlling the display

IF you want to show only 5 or 10 valus in x axis then use dimension limit in the properties

Re: Changing x-axis in cyclic group

Fri, 08 Nov 2013 06:43:10 GMT

Hi Kevin,

* If you want to reduce the X-axis to 5 - 10. (see the attachment)

* If you want to group some dimensions in X-axis.

Properties -> Edit Group (left bottom) -> New -> Give the Group name, select type of Drill (Drill-Down Group/Cyclic Group) -> Add the required fields -> (Promote/Demote if required) -> OK -> OK -> Apply, OK.

Then you can able to see a round shaped arrow to the left bottom of your chart. (see the attachment).

If you click on the arrow, dimensions will change accordingly.

I welcome all your comments and feedback.