0 Replies Latest reply: Aug 19, 2011 6:24 AM by Arno van Wouwe RSS

    pivot graph instead of pivot table

    Arno van Wouwe

      Hi all,

       

      I have a diagram that displays several lines, one per supplier. In order to make my diagram future-proof (new suppliers do pop up) I want QlikView to calculate the list of series in a diagram: if the selection has three suppliers --> three lines.

       

      However I have not found any possibility to dynamically create elements in the Y-axis. When I create a dynamic label expression that then this does not result in QlikView creating a line for every resulting label, and when I add a dimension on the X-axis then I still have one line, but it tries to go through multiple datapoints for one X-coordinate, resulting in vertical movements on every X-axis point.

       

      Bars seems to handle adding a dimension better, but I really need lines, and on top of that the bars automatically stack.

       

      Essentialy what I am looking for is a pivot graph, analogous to the pivot table that does exist. Without it I have a fragile application with many similar expressions that I have to manually maintain.

       

      Anyone have an idea?

       

       

        Arno