topic Set analysis using only in QlikView

Set analysis using only

Thu, 28 Jan 2010 17:10:47 GMT

sum({<MonthendDate = {"<=$(=Only(MonthendDate))"}, MonthendDate = {">=$(=addmonths(=Only(MonthendDate),-12))"}>} XXNET)

I am having difficulty with a set analysis, I am trying to have a chart show the monthenddate selected and the 12 months going backwards. My expression is not working , wondered if anyone can see what is wrong.

Thank you

Adrian

Set analysis using only

Thu, 28 Jan 2010 17:17:09 GMT

try the following

sum({<MonthendDate = {"<=$(=Only(MonthendDate))>=$(=addmonths(=Only(MonthendDate),-12))"}>} XXNET)

Nimish

Set analysis using only

Thu, 28 Jan 2010 17:40:53 GMT

Unfortunately, your suggestion did not work either.

I have made a little example of sales for previous 3 months may you or someone else can help.

Regards

Adrian

Set analysis using only

Thu, 28 Jan 2010 17:44:45 GMT

example attached

Set analysis using only

Miguel_Angel_Baeyens — Thu, 28 Jan 2010 17:46:50 GMT

Try

sum({<MonthendDate = {">=$(=addmonths(Only(MonthendDate),-12))<=$(=Only(MonthendDate))"}>} XXNET)

. Very similar but not the same. Do you have the same Monthend format in all records?

Set analysis using only

Thu, 28 Jan 2010 17:47:05 GMT

Still not working see example

Set analysis using only

Thu, 28 Jan 2010 17:48:01 GMT

See example

Set analysis using only

Miguel_Angel_Baeyens — Thu, 28 Jan 2010 17:48:53 GMT

There's no example here...

Set analysis using only

Thu, 28 Jan 2010 18:01:33 GMT

Thank you your expression works in my example document but I can not make it work in the document I am working on.

I have looked at the format of the MonthendDate and exported it to excel, the underlying date is a number with no rounding so I can not understand why it would not work.

Any more ideas?