Qlik Community

QlikView Creating Analytics

Discussion Board for collaboration related to Creating Analytics for QlikView.

Not applicable

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.

Tags (2)
1 Solution

Accepted Solutions
datanibbler
Esteemed Contributor

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

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

View solution in original post

3 Replies
datanibbler
Esteemed Contributor

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

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

View solution in original post

pradeepreddy
Valued Contributor II

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

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

Not applicable

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

Thank you for the quick and accurate respons!