I have a line chart that is having 4 different expressions.
That is, for each line in the chart, there is one expression and in legend, an expression-name corresponding to the respective line color.
It looks like what is given here
Now my problem is, I am not able to select one expression to see its corresponding line alone.
(I know that in case of multiple line charts where there is only one expression and the different lines corresponds to different values of some dimension, it is possible to select the dimension value by clicking the same from legend. But in this case, I am having different expressions for each line)
Is there any way by which I can get a selection over the required expression?
That is, if I want the chart to display only expression 1, I should be able to do it, clicking exp 1 in the legend.
Adding the 4 seperate expressions into a cyclic group will facilitate you to see only one expression/line at a time.
My requirement (or rather client's requirement!) is to display all 4 lines (4 expressions) in one chart by default and from that chart user should be able to select one expression if they want to see that alone in the chart.
Are you working on QV 11 version bcoz there is a feature in QV 11 for dynamically selections of Expressions as well as Dimensions in a chart. Just look at the demo Application(What's New in Qlikview 11).
Hi the only way i would think you can do this is to restructure your data, from looking like:
Dim Exp1 Exp2 Exp3
Q1/2011 1 0.3 0.6
Q1/2011 1 0.4 0.2
to look something like this:
Dim Exp ExpType
Q1/2011 1 Exp1
Q1/2011 1 Exp1
Q1/2011 0.3 Exp2
Q1/2011 0.4 Exp2
Q1/2011 0.6 Exp3
Q1/2011 0.2 Exp3
Then you could add the ExpType as a dimension and then just have a sinle expression, you will then be able to select it in your graph (this is assuming your expressions are simple counts / sums. however more complex functions could also be replecated but you would need to write these in your script too.
For this you can try Dynamic Expressions by selecting Conditional option in Expression tab.
You can find the example of this implementation in What's new in Qlikview Demo
Hope this helps you.