3 Replies Latest reply: Nov 24, 2014 11:44 AM by Aart Noordegraaf RSS

    How to create a dynamic chart in QV with different thresholds?

      My problem is as follows: I need to create a chart that captures not only the cumulative revenue per buyer but also the different thresholds in one graph. And it must be interactive so that i can select the buyer and the graph shows the values for that buyer only.

       

      See attached excel for an simple example. The exmaple contains 13 weeks, two buyers and three trehsholds. I would like to have a graph in QV similar to that in excel, however it should be dynamic. So when i select another buyer the graph (and thresholds) change accordingly.

       

      Any answers will be appriciated.