Qlik Community

Qlik Healthcare User Group

Highlighted
m2r4miller
New Contributor III

Data Driven Dynamic Static Max value in Charts

There are certain use cases where you may not want the Y-axis max value to dynamically change as selections are made. The attached document is my solution to the question "How do I set a Static Max value in a chart that doesn't require me to update the value as the underlying data grows in the application over time?".

I hope others may find this useful!

The attached document discusses the following functions:

Ceil()

Max()

Aggr()

Enjoy!

Mark Miller

2 Replies
Not applicable

Re: Data Driven Dynamic Static Max value in Charts

Is it possible to do this with variables used as the expression?

m2r4miller
New Contributor III

Re: Data Driven Dynamic Static Max value in Charts

Sorry for the delay, but I would think you could use variables in the expression.