Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
We have a query regarding trellis chart, hope we can get help from you on solving the same.
We have a situation where in a trellis chart we have different scales (one chart has 10 as maximum Y-Axis and the other one has 30000 as the maximum on Y-Axis), we need to apply separate scales for each graph individually (according to the highest value it has). As normal functionality QlikView will scale all the graphs by taking the maximum of Y-Axis of all, with this the graph which contain very low values will look almost flat when viewed with all other entries, but when we drill down on this graph the scale will change according to the values present for that graph only, we want this behavior to be default for the normal view also.
Also, please find attached some screen shots of the same.
Your help is much appreciated.
Hello,
You can create a new field in your dimensions table where you set the value for each of them, and set it as maximum value, so when you drill down in your chart, your maximum is dynamically changed.
There are not attached documents to your post, by the way.
Hope that helps