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
expression 1 : count(numODA)
expressione 2 : sum(totORDIN)
I don't think this is possible. QlikView doesn't have this functionality. Create multiple charts or you have to live with this
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?
Not sure I follow your question
This is an example of what I meant
Yes this is possible
Max(TOTAL <descTipoRDA> [Costo ordini [€]])
assuming Costo ordini [€] is a field
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
Retrieving data ...