topic Re: LINE CHART ISSUE in QlikView

LINE CHART ISSUE

Tue, 15 Sep 2015 14:18:28 GMT

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

Re: LINE CHART ISSUE

MK_QSL — Tue, 15 Sep 2015 14:26:19 GMT

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

Re: LINE CHART ISSUE

settu_periasamy — Tue, 15 Sep 2015 14:26:58 GMT

Hi,

can you post the sample qvw?

Re: LINE CHART ISSUE

Tue, 15 Sep 2015 14:27:27 GMT

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

Re: LINE CHART ISSUE

MK_QSL — Tue, 15 Sep 2015 14:29:44 GMT

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

Re: LINE CHART ISSUE

Tue, 15 Sep 2015 17:16:33 GMT

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

Re: LINE CHART ISSUE

caio_caminoski — Tue, 15 Sep 2015 17:38:24 GMT

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..

Re: LINE CHART ISSUE

Wed, 16 Sep 2015 11:57:24 GMT

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