Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Not applicable

Dynamic value max in Y axes

hello everyone, I have a bar graph with trellis enabled. What I would like is to make the Y-axis dynamic with the maximum value for each value of the dimension

Labels (1)
1 Solution

Accepted Solutions
stigchel
Honored Contributor

Re: Dynamic value max in Y axes

That's not possible but maybe this will help you work around that, no idea who wrote that ...

Getting the most out of a Trellis bar chart, some tricks

7 Replies
Not applicable

Re: Dynamic value max in Y axes

for completeness...

expression 1 : count(numODA)

expressione 2 : sum(totORDIN)

Re: Dynamic value max in Y axes

I don't think this is possible. QlikView doesn't have this functionality. Create multiple charts or you have to live with this

Not applicable

Re: Dynamic value max in Y axes

I was thinking of taking the max group by value dimension. And if I wanted to turn the chart into a table? It's possible to have a column with the max in a group?

Re: Dynamic value max in Y axes

Not sure I follow your question

Not applicable

Re: Dynamic value max in Y axes

This is an example of what I meant

stigchel
Honored Contributor

Re: Dynamic value max in Y axes

That's not possible but maybe this will help you work around that, no idea who wrote that ...

Getting the most out of a Trellis bar chart, some tricks

Re: Dynamic value max in Y axes

Yes this is possible

Max(TOTAL <descTipoRDA> [Costo ordini [€]])

assuming Costo ordini [€] is a field