you can do that.
please see the attachment.
see in Tab Reports.
Whats New in QlikView11.qvw 5.8 MB
You could enable or disable the expressions representing thouse KPI's. To do this you could add buttons for each one of them and enable the expressions on conditions of thouse buttons being clicked.
If you want to change what each axis represents, you could use cyclic groups to cycle arrond different dimensions:
Yes it can probably be done.
I've done the same thing but with a line chart with a single line in it.
The user can select one of several metrics from a list to the left, and that metrics is then shown in the line chart.
We also set up the dimension (x-axis) of the chart to be driven dynamically, specifically it is possible to choose whether months or individual dates should be shown horizontally.
Some tricks are needed to achieve the above though, don't think you can do it with QS out of the box.
We used two different extensions from Qlik Branch.
1. CVL Dimenlist is used to drive the dynamic dimension
2. Qlik Sense Option List is used to drive the dynamic changing of metrics
You need to couple the above extensions with some inline tables where you define the metric names and their associated formulas, as well as some IF statements in the expressions for the chart measures.
I know... a sample app would be useful. Too busy right now, hopefully the above will get you started in the right direction.
Did you tried this, without using the extensions.
LOAD one table with Measures like Sales, Gross margin, Gross margin%, and use this expression in chart
=Pick(Match(Only(Measure), 'Sales', 'Gross margin', 'Gross margin%'), Sum(Sales),, Sum(Sales) - Sum(CostPrice), Sum(Sales)/Sum(CostPrice))
Hope this helps you.