LINE CHART ISSUE

[#1]

I have a variable (vXYZ) which contains the aggregated dollars, I can't sum them .  I need to show them in a Line chart with Month as a Dimension , so I need to show the variable (vXYZ) values for each month on the Line, chart.

Currently I have a Month Dimension and in the Expression I have $(vXYZ).   I do get the Value for the  selected month only.  I would like to see those values for each month forming my line.

Can you please help

[MK_QSL]

How you define the variable? Can you provide sample data or application to work?

[settu_periasamy]

Hi,

can you post the sample qvw?

[#4]

Variable is calculating the difference between the dollars for the (Current MOnth - Previous MOnth)

[MK_QSL]

Provide sample/dummy data... or sample application.

[#6]

YRMTH	Year	Month	Sales (YTD)
201507	2015	Jul	20
201507	2015	Jul	30
201506	2015	Jun	40
201505	2015	May	55
201506	2015	Jun	65
201501	2015	Jan	75
201501	2015	Jan	80
201504	2015	Apr	90
201507	2015	Jul	95
Sales Data is Cumulative

I am trying to calculate Month to Date from this Year to Date data

the variable vXYZ is 

(Sum( {<Year={$(=Max(Year))}, Month={$(=vCurMth) } >} Sales)

-

Sum( {<Year={$(=Max(Year))}, Month={$(=vPrevMth)} >} Sales))

vCurMth =  Month

vPrevMth = Prev_Month  which is (Month-1) in the script

[caio_caminoski]

Try

(Sum( {<YRMTH={$(=Max(YRMTH))} } >} Sales)

-

(Sum( {<YRMTH={$(=Max(YRMTH)-1)} } >} Sales)

Hope it helps

Best regards

Caio

...

Now I see that it is a line chart and not a text box... I don't think my suggestion will work..

[#8]

YRMTH	Year	Month	Sales (YTD)
201507	2015	Jul	20
201507	2015	Jul	30
201506	2015	Jun	40
201505	2015	May	55
201506	2015	Jun	65
201501	2015	Jan	75
201501	2015	Jan	80
201504	2015	Apr	90
201507	2015	Jul	95
Sales Data is Cumulative

I am trying to calculate Month to Date from this Year to Date data

the variable vXYZ is

(Sum( {<Year={$(=Max(Year))}, Month={$(=vCurMth) } >} Sales)

-

Sum( {<Year={$(=Max(Year))}, Month={$(=vPrevMth)} >} Sales))

vCurMth =  Month

vPrevMth = Prev_Month  which is (Month-1) in the script