Chart sum with set expression question

Anonymous — Thu, 11 Mar 2010 21:31:21 GMT

Hi guys,

in my chart I need to calculate the sum of values by season: winter, spring, summer, autumn.

In the source data I have just Year and Month information. So in the load script I create a new field SEASON_YEAR:

Month Year Season_Year

01 2005 2005

02 2005 2005

... ... ...

11 2005 2005

12 2005 2006

01 2006 2006

02 2006 2006

... ... ...

So, I thought I would add 4 expressions symbolizing the 4 year seasons:

sum({<Month={12,01,02}, Year=Season_Year>} Values) - winter

...

sum({<Month={09,10,11}, Year=Season_Year>} Values) - autumn

However, this does not seem to work. At least the part Year=Season_Year does not work for sure.

What is a correct way to write this expression?

Thanks in advance.

Valera

Chart sum with set expression question

Oleg_Troyansky — Thu, 11 Mar 2010 21:58:46 GMT

Valera,

the reason the Set Analysis condition doesn't work is because the Set Analysis condition is being evaluated "globally", outside of the individual Chart cell. You can check for Year = 2010, but you can't compare two Year fields from the same row... Hope it makes sense.

What I think you should do is use your Season_Year as a dimension instead of the Year - that way, it should work correctly.

Regards,

topic Chart sum with set expression question in QlikView

Chart sum with set expression question

Chart sum with set expression question