Hi, I have a user requirement about the display of a line/bar char, it would be easier to explain with the following example:
I have 2 dimensions:
Date: Jan 2005, Feb 2005, Mar 2005, ..., Mar 2010, Apr 2010
Industry: Commerce, Construction
I have a line chart with this dimensions with an expression of Change Percentage, wich give me the following result:
When I choose both (Commerce and Construction) in the Industry listbox what the chart does its take the the UNION of both scales and paint the lines according to that scale, like this:
The user wolud like to analyse the shape of the curve (ups and down) instead of compare the difference between both curves. So the expected result its the following (I made this in paint so I hope its not a problem )
Like you can see, the shape of the curve hasn't change, what change its the scale used in the second line.
1. Do not use Industry dimension. Use only Date. Instead of one expression, create two: if(Industry='Commerce', <your current expression>), and label it Commerce and similar for Construction.
2. Yes, but if your have more than 2, you don't have enough axes. Certainly you can assign many values for each left and right sides.
The price of this solution - it cannot handle dynamically any changes in the set of values in Industry. It is expected that they stay the same. Actually, it makes less sense with more than 2 values because it is not clear for user which line is using left scale and which is using right.
I tried your solution . The problem I'm having is that the chart only displays the first of them, it doesn't show the second expression I prepare an example qvw file for testing, but I don´t know how to attach files to the post. As soon as I find out how to do it, I'll attach teh file so I can show you my problem and hopefully you could help me correct my mistake