Help with set analysis

[onetwothree123]

I have two variables

Currentday = 06/11/2012

Previousmonth = 05/12/2012.

I am trying to write a set expression in my line chart using these two variable where date lies between Currentday to Previous month

Date is the dimension

[Miguel_Angel_Baeyens]

Hi AJ,

Is that the latest version I uploaded? vCurrentDate will always be greater than vPreviousDate and I corrected that mistake in the second version.

Regards.

Miguel

[onetwothree123]

Miguel,

I just see one version from you.

qcomVariablesDate.qvw

Its an images from that version only.

vCurrentDate will always be greater than vPreviousDate ?

I didn't get that

[Miguel_Angel_Baeyens]

Hi AJ,

Indeed, vCurrentDate will always be greater than vPreviousDate, the latter is defined to be one month before. You can see that in the Settings menu, Variable Overview.

The logical expression must be (from the lower date -one month ago- to the higher -today):

>=vPreviousDate<=vCurrentDate

Hope that makes sense.

Miguel

[onetwothree123]

Miguel,

I got it.

But ran into another problem may be it is because of data I have in Excel.

Its not doing the Avg. of Deposit based on dates

Basically its giving me the same value  in line chart as it is in Excel.

In excel I have Date field with dates from May2010 to Aug2012.