Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik GA: Multivariate Time Series in Qlik Predict: Get Details
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Chart with Cycle expression - change axis limit and number

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

1 Solution

Accepted Solutions
pat_agen
Specialist
Specialist

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

View solution in original post

2 Replies
pat_agen
Specialist
Specialist

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

Not applicable
Author

Thanks mate, perfect!