Line Chart

[#1]

I want to have a line chart for some Amount with respect to Calendar year based on one dimension I'm able to do so but as a output chart it is showing me only 1 year dots instead of a complete line for different years; no filters applied to list box to any of the sheets.

Y >> Amount

X >> Calendar years

Third >> other dimension

Thanks..please let me know if i need to post some more info.

[raghavsurya]

hi Achal,

Can you post ur sample qvw file so that I can have a check.

Regards,

Raghav

[#3]

You have to add second dimension

ex if you want to show location wise yearly collection then

use year as first dimension, location as second dimension

and write expression as sum(amount)

this way you will get year on x-axis sum(amount) on y-axis (left side) and location as legends at right side.

if you change the order of dimension then

you get location on x-axis and year as legend at right side.

[#4]

Thanks Shubhasheesh ,

I did that already but my issue is that I'm not able to see a cont. line connecting diff year it shows me only for one year in chart even though it got value for diff years.

Thanks Raghav, I can not send you d orig. one due to some restrictions but i'm just adding a sample file which got the same problem it got atleast 2 years but my original file showing me only for one year.

pls note m utilizing rank function.

[raghavsurya]

Hi Achal,

I could see that the rank function which u have put is not returning the values for all / two years and hence the issue.

Regards,

Raghav

[#6]

Probably.

any idea how to rectify, as I can not only plot rank i need to show rev vs year based on third P dimension.

[#7]

do I need to put anything for year as well in my expression for the rank to work perfectly as desired?