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

[#1]

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.

[datanibbler · Accepted solution]

Hi,

easy: The tresholds can be displayed as "position lines" (on the "presentation" tab of the dialog) and those can be made into an expression that is dependent on the selection of one buyer.

Just use several dimensions and make them dependent on the selection using GETSELECTEDCOUNT()

=> When the user clicks on the  column for one buyer, the graph will change, the tresholds for that specific buyer will
      be displayed and you can still have one dimension "day" or so - just make that independent of the selection.

HTH

Best regards,

DataNibbler

[PradeepReddy]

Please find the attached QVW application. Might be helpful for you.

[#4]

Thank you for the quick and accurate respons!