topic Chart with Cycle expression - change axis limit and number in QlikView

Chart with Cycle expression - change axis limit and number

Tue, 05 Apr 2011 16:37:28 GMT

Hello Everyone,

I have a chart that is a stacked barchart. There is a cycle expression group:

1. straight count

2. straight count as a percentage of the dimension (so I get 100% stacked bar charts)

The cycling between them works fine. What I want though, is when I am looking at the 100% expression I want the y axis to max at 1 and the number to be shown in percentage. I want the axis to be raw values for the straight count with no limit.

Any ideas how to achieve this?

Thanks

Gareth

Chart with Cycle expression - change axis limit and number

pat_agen — Tue, 05 Apr 2011 17:06:00 GMT

hi Gareth,

to achive this you need to set your Axes attributes twice , once for each of the expressions you are cycling. To do this toggle to the expression you wish to modify (the straight count as a percentage). Open your chart properties, go to the axes tab make sure the Scale etc. is how you want it.

When you are using a cyclic group the Expression axes box on the axes tab only shows the current used expression. Hence this workaround.

The number formatting shoudl simply be achieved using the chart property -> number tab.

hope this helps

Chart with Cycle expression - change axis limit and number

Tue, 05 Apr 2011 19:59:50 GMT

Thanks mate, perfect!