topic Line Chart in QlikView

Line Chart

Tue, 21 Dec 2010 11:50:12 GMT

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.

Line Chart

raghavsurya — Tue, 21 Dec 2010 12:17:29 GMT

hi Achal,

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

Regards,

Raghav

Line Chart

Tue, 21 Dec 2010 12:29:46 GMT

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.

Line Chart

Tue, 21 Dec 2010 12:52:36 GMT

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.

Line Chart

raghavsurya — Tue, 21 Dec 2010 13:15:54 GMT

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

Line Chart

Tue, 21 Dec 2010 13:32:33 GMT

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.

Line Chart

Wed, 22 Dec 2010 14:55:18 GMT

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